record limit

New Member Joined: Sep 15, 2002 Posts: 2

When my guest book records reached about 2,800, the whole program slow down. It took minutes to open the guest book. My observation was that it spent quit a long time on retrieving the records. After I deleted the old records, it took seconds to open the guest book.

Does it means there is a limitation on guest book records?

I want the old guest book record by accessible by visitors for viewing only. What can I do? Do I have to install another set of KISGB-old in the sever? Is there any way I can prevent visitors leave message in the old guest book?

Site Admin/Owner Joined: Aug 27, 2002 Posts: 17088

There is no limit. But, the way KISGB is designed, flat file vs. rdbms, there is no easy way to optimize it, other than memory and cpu. The only current suggestion is to run multiple copies, kind of like an archive. There are others who do this. To be truthful, I never expected, way back when, that KISGB would be the success it is Smile

. I need to address this in an upcoming release.

Posted: Wed Jul 02, 2003 9:07 pm

If I create another KISGB copy to access old messages, how can I make it as read only? Or how to prevent visitors post message in the old KISGB?

Thanks.

Posted: Wed Jul 02, 2003 9:10 pm

Just change permissions on the file (and/or set admin_from_web = FALSE; or remove the sign gb link. Several options Smile