I have 139900 rows in the table. It looks like if I project a temp table with selected rows and then build the next view on the temp table it helps to speed things up. ___________________________________________________________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of James Bentley Sent: Wednesday, August 04, 2010 9:49 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Slow database
When was the last time the disk drives were defragmented. Reloading the database will not be effective if the files are fragmented on the hard drive. Jim Bentley American Celiac Society [email protected] tel: 1-504-737-3293 From: Bob Thompson <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Wed, August 4, 2010 5:10:01 PM Subject: [RBASE-L] - Re: Slow database When the database is running slow, does the task manager show high cpu and if so what is the process? What network consumption does the task manager show at that time? I agree that any anti virus programs need to have *.rbx files accepted. I believe reporting back what process is taking CPU time will help clear up the question, or at least point to where the issue is. Bob Thompson LaPorte, IN 219-363-7441 Sent from my iPod On Aug 4, 2010, at 4:27 PM, Charles Parks <[email protected]> wrote: It is reloaded nightly. From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Wednesday, August 04, 2010 4:10 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Slow database How often is the database packed/reloaded? Does it need to be done every day? Karen
