Jean-Christophe Deschamps. Thank you for thoughtful reply. I will show it my 
boss when he return on Tuesday(Monday May 30th is Memorial Day. Thank you.



Date: Fri, 27 May 2011 03:27:44 +0200
To: [email protected]
From: [email protected]
Subject: Re: [sqlite] Is it possible to optimize the read performance of a C++ 
app using sqlite pragma journal_mode = wal & pragma wal_checkpoint?

Here's the download link promised.

The build is for x86.  Take some time to carefully read the explanations at top 
of the source code.

The function you may want to test is typos().  It can be significantly 
simplified/sped up for Levenshtein-only distance.

I use it for instance to identify returning customers registering again with 
typos or small changes in names, first names, street address, city, etc.  Also 
very useful for validating zip/city couples against a known-good table.


--
          Jean-Christophe Deschamps
eMail:         [email protected]
SnailsTo:   1308, route du Vicot
          40230 Saint Jean de Marsacq
                    France
GSM:         +33 (0)6 15 10 19 29
Home:        +33 (0)5 58 77 71 79
                                          
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to