At 07:02 AM 1/9/2003 -0600, Steve Wills wrote:
Slower than molasses in January! I don't know what's happenin' here. I
have a table, 'CODES_COUNTIES', that contains 95 records f/the counties
of TENN. 2 are indexed, CountyFIPS and District (another geo-political
unit of the client). The DB has become rather large, but I've had some
at least 2x as big.
Now, whenever I use a WHERE||ORDER BY clause on these 2 fields, it takes
10's of minutes or more to produce a result-set. This shouldn't take
more than maybe a second on 95 rows if it's un-indexed, much less if it
is. I'm totally bumfuzzled.
Any ideas.
Steve,
Two options:
01. DISCONNECT
SET MULTI OFF
CONN dbname IDENTIFIED BY UserrID Password
RELOAD NewDB
DISCONNECT
DELETE dbname.RB?
RENAME NewDB.RB? dbname.RB?
SET MULTI ON
CONN dbname IDENTIFIED BY UserrID Password
or
02. If you are using The Glorious R:BASE 2000 (ver 6.5++),
Build:1.862xRT03 or higher, you may try:
PACK INDEX FOR TableName
This will PACK all indices for the specific table, even in
Multi-User environment
or
PACK INDEX
This will pack all the indices for currently connected
database, even in a Multi-User environment.
or
You can SET a flag to disable "Index Only" SELECT
retrievals. The command is SET INDEXONLY OFF.
The default is ON.
Good Luck!
Very Best Regards,
Razzak.
