I have 11 Rules on my Hist table with 300,00 rows and we do a Close the day routine that has several Update commands and it runs in less than 60 seconds. I do have 2 FK's and 9 regular Indexes.
As George of the Jungle would say..... just lucky I guess! Marc From: Lawrence Lustig Sent: Thursday, February 11, 2010 10:55 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Speed issues << Stuff like this bugs me... it has been this way for 10 years, now it is wrong. >> While it's possible that something changed in a recent R:Base release, it's also possible that you recently exceeded some magic number of records in the table which forces R:Base to perform the SELECT used in the rule in a temp file instead of in memory. If that's the case, the rule would suddenly slow down substantially for each of the 100,000 executions necessary in reloading the table. -- Larry
