John, That number of records should not be an issue. Whenever I see a slowdown (or perceive one) I do a pack index to see if the index pointers are broken for some reason. Otherwise a reload many times catches a problem. Also, look at how your indexes are listed. I have made some great improvements in the past by experimenting with certain indexes, and using multiple indexes. Best, Bob C
-----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of John Croson Sent: Thursday, July 17, 2008 3:07 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Database Limits Hi All. Seems like a quiet day, and doing a bit of cleanup on this DB, so thought I'd ask this question. Is there a maximum record / table count for RBase? I've got a 4 table database that's getting quite slow. Table 1 = 57,800 Records Table 2 = 169,500 Records Table 3 = 57,200 Records Table 4 = 56,800 Records The data files are on a 100mb LAN, in a windows share. TIA! John Croson [EMAIL PROTECTED] http://pcnorb.blogspot.com/ http://pcnorb.homelinux.org/
