BTREE EXTRACT TAKING LONG TIME (AREV Specific)
At 01 APR 1999 06:59:45PM F.H.SMITH wrote:
I HAVE A CERTIN BTREE.EXTRACT IN A PROGRAM THAT IS NOW TAKING A LONG TIME TO EXECUTE.
UNTIL LAST WEEK IT WOULD EXTRACT SAY 60 KEYS FROM A 3000 RECORD
TABLE ALMOST INSTANTLY, NOW THE SAME EXTRACT MAY BE INSTANT OR TAKE UP TO 10 MINUTES.
ANY IDEAS.
FRANK SMITH
At 02 APR 1999 12:37AM Don Bakke wrote:
Frank,
Have you rebuilt the indexes yet on this table? Are you sure that accurate keys are being returned? Does any other process take longer than normal?
At 02 APR 1999 12:09PM [email protected] wrote:
I am having the same problem. Indexes have been rebuilt. When i first installed the software everything was running fast. It ran good for appox 6 months. Now it's running slow again. Any Ideas???
At 05 APR 1999 02:04AM Curt wrote:
Check for system delimiters in the keys. Check for giant keys. There is a data problem of some sort.
At 05 APR 1999 04:27PM K Gilfilen wrote:
Does any type of search on the file in question occur normally? Is it safe to assume you are on a network? What details can you provide about it? Are any other processes on the network, ARev or other, suffering? Is the index file a similar size in bytes to the data file (e.g., if the data file is 100 kb and index file 100gb something is wrong)?
As Curt wrote, if there is a bogus record key in the data file, that could throw the index lookup into a time-consuming difficulty when it hits it. If that is the case you would have to ferret out the bad key and rebuild the indexes. Usually those bad keys appear from carelessly programmed and insufficiently tested software.