Le sam 24/07/2004 à 21:23, Steve O'Hara a écrit : > Also, LIKE doesn't use an index so don't expect great performance........
Well, although sqlite doesn't use an index, the performance of the like clause still is truly amazing to me. I'm talking hundreds of thousands of rows here, filled with paths and filenames... By the way, I wonder how indexes can be used on like clauses (design level), as I guess full-featured rdbms make use of them. But how? Anybody has a clue? -- *********************************************** [EMAIL PROTECTED] OpenPGP public key: http://www.amakuru.net/dmorel.asc
signature.asc
Description: Ceci est une partie de message =?ISO-8859-1?Q?num=E9riquement?= =?ISO-8859-1?Q?_sign=E9e=2E?=
