Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 4 of 4 total |
Slow Delphi Locate edb 2.23b2 |
Fri, Apr 8 2016 8:38 AM | Permanent Link |
Gruetzmacher | hello,
can someone confirm this: the delphi Locate method does not use available indices (and therefore slows down finding a record significantly). i was using the 2.22 series of edb before and this problem did not exist. the corresponding sql-statement in the edb manager ist fast |
Sat, Apr 9 2016 3:08 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Gruetzmacher
>can someone confirm this: >the delphi Locate method does not use available indices (and therefore slows down finding a record significantly). >i was using the 2.22 series of edb before and this problem did not exist. >the corresponding sql-statement in the edb manager ist fast It should do and fall back to using brute force when an index doesn't exist. I have an incident which I'm talking to Tim about via email that may be related - I "think" I've tracked it down to a difference in behaviour with FindKey & Locate between 2.22 and 2.23. I'm still trying to produce a test case. Roy Lambert |
Mon, Apr 11 2016 5:02 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Hendrik,
<< the delphi Locate method does not use available indices (and therefore slows down finding a record significantly). i was using the 2.22 series of edb before and this problem did not exist. the corresponding sql-statement in the edb manager ist fast >> Please email me your database catalog, relevant table files, and the example table/query that is exhibiting the issue along with the Locate call that you're using, and I'll take a look. And no, this isn't the same issue as Roy's. Tim Young Elevate Software www.elevatesoft.com |
Wed, Apr 20 2016 5:47 AM | Permanent Link |
Gruetzmacher | just to clarify:
the problem was not related to edb at all but rather the amount of data that has build up within 2 years. in fact the index was never used at all but locate could easily be modified to use it. everything is fine |
This web page was last updated on Tuesday, April 30, 2024 at 03:55 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |