Devart Forums

Further to my locate speed problem I have found that on a test set of a few thousand sha1 hashes locate fails to find the hash I am looking for (I have used a database browser to confirm that the hash is in the database.)

my commands are in this order:

sql = "create index if not exists Hashindex on InnHash(sha1)";

sql = "select * from InnHash order by md5";
(not sure if the above is necessary)

if(ShaHash->Locate("sha1", sha1, TLocateOptions() << loCaseInsensitive))

ShaHash is a UniQuery and is unidirectional


in both cases that hashes are in uppercase, but I have used the case insensitive option anyway.

The UseUnicode opton is set in the UniConnector - but cant see how this would affect it.

Interesting

I have hard coded the query by access the sqlite dll directly and a select x from table finds the required value. This will work for me anyway as this routine does not need to display the data in a table.

Was the UniQuery UniDirectional, I think that will prevent locate working correctly because it can't move backwards.

Regads, Paul.

Hello

Unfortunately I cannot reproduce this issue. Please provide me the following information:
- The DDL script for creating the InnHash table
- The DDL script for creating the index for the InnHash table
- The SQL script for inserting data that cannot be found by the Locate method
- The Delphi code that calls the Locate method (in your first post you don't specify the value of the sha1 variable)