At 05:05 PM 4/26/2005, Steve Breen wrote:
How would you speed up the process?
In a WHERE clause, R:BASE uses only one index (except when joining tables). By knowing which indexed column the R:BASE optimizer use in a WHERE clause, you can structure your conditions so that the optimizer uses the most unique (and thus most helpful) index. This is where knowing your data helps you to modify command(s) and gain speed.
On the other hand, if you are LOADing many rows of data at a time, it is considerably faster to DROP the indexes, load the data, and then rebuild the indexes. It is faster for R:BASE to build the indexes in one chunk rather than updating them as each row is loaded. You can optimize this by using CREATE INDEX command.
Tip: Always RELOAD database after deleting lots of rows.
Hope that helps!
Very Best R:egards,
Razzak.
