T
tbergman
Guest
Thanks to everyone who responded. Answers to a few questions first. DBI was not active and 0 bytes. SRT was in use but seemingly not related to problem. Upping -Bt had no effect. For Each, leave was not an improvement. Even with Character, I wasn't please with the performance. The data in the table TT1 represents a range of values (they actually represent IP addresses). There is never an overlap in the data. I was able to get great performance by having 2 indexes on TT1, one for start, one for end. Then I added a buffer for TT1 and queried like this. Find Last TT1 where TT1.Start LE TT2.Foo. Find First bTT1 where bTT1.End GE TT2.Foo. If I have both buffers, and their ROWIDs are the same, then I found the appropriate record. Very fast, problem resolved. Thanks
Continue reading...
Continue reading...