[sqlite] Question about searches

in the result set? Please note that I am using the normal command line sqlite3.exe application. I already started looking into soundex() yet unfortunately, it does not seem to be compiled into the normal command like executable. I also doubt that it would help? Any help much appreciated, Christophe

Re: [sqlite] Question about searches

problems and remap them accordingly. -- Christophe Leske www.multimedial.de - i...@multimedial.de http://www.linkedin.com/in/multimedial Lessingstr. 5 - 40227 Duesseldorf - Germany +49(0)180102 - 06 60 02 96 // +49(0)177 249 70 31 This e-mail may contain confidential information. If you

Re: [sqlite] Sample file search algorithm

in there beforehand as blobs. But then, maybe I misunderstood? -- Christophe Leske www.multimedial.de - i...@multimedial.de http://www.linkedin.com/in/multimedial Lessingstr. 5 - 40227 Duesseldorf - Germany +49(0)211- 17 80 48 94 // +49(0)177 249 70 31 ***Note our new phone number. Thank you

Re: [sqlite] SQLite version 3.6.10 - Warning

, but this may be due to the component we are using (i am not sure it is supporting the new version of sqlite.dll) Do you want me to mail you the corrupted database for further inspection? I also understand that this is not the right place for bugreports eventually. Christophe Leske

Re: [sqlite] SQLite version 3.6.10

this is what I like best about it: it does the stuff it is supposed to do, no more, but also not less. -- Christophe Leske www.multimedial.de - i...@multimedial.de http://www.linkedin.com/in/multimedial Lessingstr. 5 - 40227 Duesseldorf - Germany 0211 261 32 12 - 0177 249 70 31

Re: [sqlite] SQLite version 3.6.10 - Warning

, but this may be due to the component we are using (i am not sure it is supporting the new version of sqlite.dll) Do you want me to mail you the corrupted database for further inspection? I also understand that this is not the right place for bugreports eventually. Christophe Leske

Re: [sqlite] SQLite version 3.6.10 - Warning

information on the 25th. Thank you for your patience, -- Christophe Leske www.multimedial.de - i...@multimedial.de http://www.linkedin.com/in/multimedial Lessingstr. 5 - 40227 Duesseldorf - Germany 0211 261 32 12 - 0177 249 70 31 ___ sqlite-users mailing

Re: [sqlite] SQLite version 3.6.10 - Warning

, but how can I contribute ? -- Christophe Leske www.multimedial.de - i...@multimedial.de http://www.linkedin.com/in/multimedial Lessingstr. 5 - 40227 Duesseldorf - Germany 0211 261 32 12 - 0177 249 70 31 ___ sqlite-users mailing list sqlite-users

[sqlite] What is a Group By, having clause?

Hi, can someone point me to some docs where the difference between a normal where-clause and the Group by, and having statements are being explained? I don´t quite understand what these are actually good for. Thanks, -- Christophe Leske www.multimedial.de - [EMAIL PROTECTED] http

Re: [sqlite] What is a Group By, having clause?

[EMAIL PROTECTED] wrote: http://www.w3schools.com/sql/default.asp Thanks! That is great! -- Christophe Leske www.multimedial.de - [EMAIL PROTECTED] http://www.linkedin.com/in/multimedial Lessingstr. 5 - 40227 Duesseldorf - Germany 0211 261 32 12 - 0177 249 70 31

Re: [sqlite] What is a Group By, having clause?

Think of HAVING as being analogous to WHERE. While WHERE applies to the TABLE, HAVING applies to the results of GROUP. Here is a contrive yes, thank you. -- Christophe Leske www.multimedial.de - [EMAIL PROTECTED] http://www.linkedin.com/in/multimedial Lessingstr. 5 - 40227 Duesseldorf

Re: [sqlite] optimizing a multiple select statement

constraint failed? What does this mean? Christophe Leske www.multimedial.de - [EMAIL PROTECTED] http://www.linkedin.com/in/multimedial Lessingstr. 5 - 40227 Duesseldorf - Germany 0211 261 32 12 - 0177 249 70 31 ___ sqlite-users mailing list sqlite-users

[sqlite] contstraint failed problem

to be added are already in the idlookup table. It would be my understanding however that the or ignore statement would silently let those inserts fail if they are already in? What´s wrong here? -- Christophe Leske www.multimedial.de - [EMAIL PROTECTED] http://www.linkedin.com/in/multimedial Lessingstr

[sqlite] optimizing a multiple select statement

to do something like: insert into idlookup ( ( select * from cl1 UNION select * from cl2 UNION select * from cl3 UNION select * from cl4 UNION select * from cl5 ) where (lomi13.96 and loma13.96 and lami53.23 and lama53.23) and id not in (select id from idlookup) ) ? -- Christophe Leske

Re: [sqlite] Another set of questions

guesses in the code. -- Christophe Leske www.multimedial.de - [EMAIL PROTECTED] http://www.linkedin.com/in/multimedial Lessingstr. 5 - 40227 Duesseldorf - Germany 0211 261 32 12 - 0177 249 70 31 ___ sqlite-users mailing list sqlite-users@sqlite.org http

[sqlite] Enforcing Uniqueness for tables created using a select statement?

Hi, i am creating my table as such: create temp table idlookup as select id from ... I would like ID to be unique in my idlookup table. How would I do this using this construct? Or is it impossible? -- Christophe Leske www.multimedial.de - [EMAIL PROTECTED] http://www.linkedin.com

Re: [sqlite] Problems using AUTOINCREMENT row IDs in indexes

that. Any chance to spare the ID field and get an index on the rowid for a given table? Christophe Leske www.multimedial.de - [EMAIL PROTECTED] http://www.linkedin.com/in/multimedial Lessingstr. 5 - 40227 Duesseldorf - Germany 0211 261 32 12 - 0177 249 70 31

Re: [sqlite] Problems using AUTOINCREMENT row IDs in indexes

. Christophe Leske www.multimedial.de - [EMAIL PROTECTED] http://www.linkedin.com/in/multimedial Lessingstr. 5 - 40227 Duesseldorf - Germany 0211 261 32 12 - 0177 249 70 31 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin

[sqlite] Two questions

that table. Are indices also used for sorting results, or do they do just apply for searching? Thanks in advance, Christophe Leske www.multimedial.de - [EMAIL PROTECTED] http://www.linkedin.com/in/multimedial Lessingstr. 5 - 40227 Duesseldorf - Germany 0211 261 32 12 - 0177 249 70 31

[sqlite] Another set of questions

I being clear? -- Christophe Leske www.multimedial.de - [EMAIL PROTECTED] http://www.linkedin.com/in/multimedial Lessingstr. 5 - 40227 Duesseldorf - Germany 0211 261 32 12 - 0177 249 70 31 ___ sqlite-users mailing list sqlite-users@sqlite.org http

Re: [sqlite] Another set of questions

for that case, but if the new result set has LESS results than the previous one, then I end up with a temporary table holding the new result set and leftovers from the previous one... -- Christophe Leske www.multimedial.de - [EMAIL PROTECTED] http://www.linkedin.com/in/multimedial Lessingstr. 5

Re: [sqlite] Sqlite3 lock issue with NFS and read-only queries

PRAGMA omit_readlock=ON; Hm, should be documented, no? I could use that as well... Just wondering if this has any speed advantages? -- Christophe Leske www.multimedial.de - [EMAIL PROTECTED] http://www.linkedin.com/in/multimedial Lessingstr. 5 - 40227 Duesseldorf - Germany 0211 261 32 12

Re: [sqlite] Two questions

a smaller file? In the example provided, the iDs are exactly the same, yet they are there twice... Christophe Leske www.multimedial.de - [EMAIL PROTECTED] http://www.linkedin.com/in/multimedial Lessingstr. 5 - 40227 Duesseldorf - Germany 0211 261 32 12 - 0177 249 70 31

Re: [sqlite] Another set of questions

to make things faster better cheaper. It IS doing what I want. However, it does not run on lower-spec machines, which is why i am trying to optimize anything available. Christophe Leske www.multimedial.de - [EMAIL PROTECTED] http://www.linkedin.com/in/multimedial Lessingstr. 5 - 40227

Re: [sqlite] Another set of questions - subject line - will do ! :-)

Any chance that you could hint at the subject matter of the questions in the Subject line ? In this case it would appear to be Performance ... Helps to get your questions answered ! ;-) Yes, will do so. My apologies. Christophe Leske www.multimedial.de - [EMAIL PROTECTED] http

[sqlite] Condition on several tables

to build several statements which all have the where clause in there. Isn´t there something more tersed? -- Christophe Leske www.multimedial.de - [EMAIL PROTECTED] http://www.linkedin.com/in/multimedial Lessingstr. 5 - 40227 Duesseldorf - Germany 0211 261 32 12 - 0177 249 70 31

Re: [sqlite] Condition on several tables

, but you have to apply the WHERE constraint only once because all the tables are identical. Do you mind elaborating on this point? Is that what Igor wrote me? Christophe Leske www.multimedial.de - [EMAIL PROTECTED] http://www.linkedin.com/in/multimedial Lessingstr. 5 - 40227 Duesseldorf

Re: [sqlite] Condition on several tables

) and so forth. Since it is depending on the distance from the ground and the rtree table only works with coordinates, i cannot really include the class-attribute into the rtree, hence several rtrees. -- Christophe Leske www.multimedial.de - [EMAIL PROTECTED] http://www.linkedin.com

[sqlite] Getting the size of a in-memory table somehow?

elements when needed. Thanks for any info, -- Christophe Leske www.multimedial.de - [EMAIL PROTECTED] http://www.linkedin.com/in/multimedial Lessingstr. 5 - 40227 Duesseldorf - Germany 0211 261 32 12 - 0177 249 70 31 ___ sqlite-users mailing list sqlite

[sqlite] Size of a memory DB?

Hi, is there a way to get the size of a :memory: db in the sqlite3.exe command line interpreter? Or any other way? -- Christophe Leske www.multimedial.de - [EMAIL PROTECTED] http://www.linkedin.com/in/multimedial Lessingstr. 5 - 40227 Duesseldorf - Germany 0211 261 32 12 - 0177 249 70 31

Re: [sqlite] Size of a memory DB?

with only 3 fields? (string, and two ints?) -- Christophe Leske www.multimedial.de - [EMAIL PROTECTED] http://www.linkedin.com/in/multimedial Lessingstr. 5 - 40227 Duesseldorf - Germany 0211 261 32 12 - 0177 249 70 31 ___ sqlite-users mailing list sqlite

Re: [sqlite] How to speed up read-only databases?

Speedup tip: http://article.gmane.org/gmane.comp.db.sqlite.general/41990 Hello Mike, first of all, thank you for your tips. Yes, i saw that posting, and i am already using it in my code. But thanks again, -- Christophe Leske www.multimedial.de - [EMAIL PROTECTED] http

Re: [sqlite] How to speed up read-only databases?

How many memory has your embedded project? You can create a new in-memory database and copy there your database data. That´s what i am currently doing, but we are using too much memory this way, we are out of specs. -- Christophe Leske www.multimedial.de - [EMAIL PROTECTED] http

[sqlite] Compressing read-only dbs?

Hi, i was wondering if there is any compression/decompression extension for read-only databases other than Dr Hipps compression extension, which unfortunately is financially out of scope for my current project. Thanks, -- Christophe Leske www.multimedial.de - [EMAIL PROTECTED] http

Re: [sqlite] Compressing read-only dbs?

How about storing the DB file in a cramfs filesystem Forgot to say that this is Windows XP, sorry. -- Christophe Leske www.multimedial.de - [EMAIL PROTECTED] http://www.linkedin.com/in/multimedial Lessingstr. 5 - 40227 Duesseldorf - Germany 0211 261 32 12 - 0177 249 70 31

Re: [sqlite] Compressing read-only dbs?

looks pretty promising, is there any extension to sqlite which could read a DB file from it under Windows? -- Christophe Leske www.multimedial.de - [EMAIL PROTECTED] http://www.linkedin.com/in/multimedial Lessingstr. 5 - 40227 Duesseldorf - Germany 0211 261 32 12 - 0177 249 70 31

Re: [sqlite] How to speed up read-only databases?

not satisfy my criteria for a lean and slim SQlite3 db access (read command line interpreter) I can use in my DVD-ROM project. -- Christophe Leske www.multimedial.de - [EMAIL PROTECTED] http://www.linkedin.com/in/multimedial Lessingstr. 5 - 40227 Duesseldorf - Germany 0211 261 32 12 - 0177 249 70

Re: [sqlite] How to speed up read-only databases?

? -- Christophe Leske www.multimedial.de - [EMAIL PROTECTED] http://www.linkedin.com/in/multimedial Lessingstr. 5 - 40227 Duesseldorf - Germany 0211 261 32 12 - 0177 249 70 31 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin

Re: [sqlite] How to speed up read-only databases?

all minus one coloumn in general. When you obey these rules you will get very good read perfprmance from Sqlite. The cacheing is important if you are using a slow disk or flash memory. Look at shared cache mode if you have multiple users Nope, just one from DVD. Thanks again, -- Christophe

Re: [sqlite] How to speed up read-only databases?

, that will help ... Have done that. It almost doubles my database, but it is worth it. How about the cache size? or does this only pertain to databases which get inserts? (Techie note http://20bits.com/2008/05/13/interview-questions-database-indexes/) Christophe Leske

[sqlite] How to speed up read-only databases?

performance. Indices have been set, would augmenting the cache size for Sqlite do something? Grateful for any info, -- Christophe Leske www.multimedial.de - [EMAIL PROTECTED] http://www.linkedin.com/in/multimedial Lessingstr. 5 - 40227 Duesseldorf - Germany 0211 261 32 12 - 0177 249 70 31

[sqlite] More on ICU extension (windows)

database was wrongly created (it was an automatic conversion from an Access MDB file thought). Thanks for any help, -- Christophe Leske www.multimedial.de - [EMAIL PROTECTED] http://www.linkedin.com/in/multimedial Lessingstr. 5 - 40227 Duesseldorf - Germany 0211 261 32 12 - 0177 249 70 31

[sqlite] Like statement and Unicode support

looking for a precompiled version of the DLL. Thanks, -- Christophe Leske www.multimedial.de - [EMAIL PROTECTED] http://www.linkedin.com/in/multimedial Lessingstr. 5 - 40227 Duesseldorf - Germany 0211 261 32 12 - 0177 249 70 31 ___ sqlite-users

Re: [sqlite] ANN: sqliteman 1.2.0

Hi Petr, I'm glad I can announce new stable version of Sqliteman - the GUI for developers and admins: http://sqliteman.com/ I gave it a try, and it seems as if SQLiteman can´t handle extensions for databases, is this right? -- Christophe Leske www.multimedial.de - [EMAIL PROTECTED] http

[sqlite] Ambigous column

the first selection? This used to work... Can anyone help? -- Christophe Leske www.multimedial.de - [EMAIL PROTECTED] http://www.linkedin.com/in/multimedial Lessingstr. 5 - 40227 Duesseldorf - Germany 0211 261 32 12 - 0177 249 70 31 ___ sqlite-users

Re: [sqlite] Ambigous column

, that was it! I was looking for the as sub part, i didn´t know how to name my subquery. Thanks a bunch, -- Christophe Leske www.multimedial.de - [EMAIL PROTECTED] http://www.linkedin.com/in/multimedial Lessingstr. 5 - 40227 Duesseldorf - Germany 0211 261 32 12 - 0177 249 70 31

Re: [sqlite] Brain error

Use actual field names in lookup table for idField, xField and yField. Thank you! -- Christophe Leske www.multimedial.de - [EMAIL PROTECTED] http://www.linkedin.com/in/multimedial Lessingstr. 5 - 40227 Duesseldorf - Germany 0211 261 32 12 - 0177 249 70 31

Re: [sqlite] rtree extension question

80Kb. Smallest i am getting now is about 60Kb, and i can´t figure out what I did, as this is exactly the same source code, minus the manifest file. But even by readding it, the resulting dll is always bigger... -- Christophe Leske www.multimedial.de - [EMAIL PROTECTED] http://www.linkedin.com

Re: [sqlite] rtree extension question

longitudelongitude_minimal and longitudemaximal and latitudelatitude_minimal and latitudelatitude_maximal? Would that actually work? Christophe Leske www.multimedial.de - [EMAIL PROTECTED] http://www.linkedin.com/in/multimedial Lessingstr. 5 - 40227 Duesseldorf - Germany 0211 261 32 12 - 0177 249

[sqlite] rtree extension question

in for instance. Is there any function that would allow for tests like new rect is inside older rect ? Thanks for any insights, Christophe Leske ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite

[sqlite] Thank you

I would like to thank all the participatns of this list for the very useful information i got here the last days. A big thank you to everyone, including of course Mr Hipp. The rtree implementation is really quick and does work like a charm. Best regards, -- Christophe Leske

Re: [sqlite] How to speed up my queries?

database like the one I have? -- Christophe Leske www.multimedial.de - [EMAIL PROTECTED] http://www.linkedin.com/in/multimedial Lessingstr. 5 - 40227 Duesseldorf - Germany 0211 261 32 12 - 0177 249 70 31 ___ sqlite-users mailing list sqlite-users

Re: [sqlite] How to speed up my queries?

, -- Christophe Leske www.multimedial.de - [EMAIL PROTECTED] http://www.linkedin.com/in/multimedial Lessingstr. 5 - 40227 Duesseldorf - Germany 0211 261 32 12 - 0177 249 70 31 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin

Re: [sqlite] How to speed up my queries?

- it probably has to do with the fact that i am sorting at the end? -- Christophe Leske www.multimedial.de - [EMAIL PROTECTED] http://www.linkedin.com/in/multimedial Lessingstr. 5 - 40227 Duesseldorf - Germany 0211 261 32 12 - 0177 249 70 31

Re: [sqlite] How to speed up my queries?

,-1,6.950052,44.354508); INSERT INTO table VALUES('San Bernolfo',6,-1,7.039278,44.263371); INSERT INTO table VALUES('Murenz',6,-1,6.998868,44.348969); INSERT INTO table VALUES('Bagni di Vinadio',6,-1,7.074884,44.290033); -- Christophe Leske www.multimedial.de - [EMAIL PROTECTED] http://www.linkedin.com

Re: [sqlite] How to speed up my queries?

-- TIME for statement:2792 -- 11 A 3 field index (class_dds, latitude_dds, longitude_dds): -- TIME for Between statement:2783 -- 11 -- TIME for statement:2762 -- 11 -- Christophe Leske www.multimedial.de - [EMAIL PROTECTED] http://www.linkedin.com/in/multimedial Lessingstr. 5 - 40227

Re: [sqlite] How to speed up my queries?

Christophe Leske schrieb: Question, have you tried an index on class_dds, longitude_DDS, and latitude_DDS? CREATE INDEX tableidx ON table (class_dds, longitude_DDS, latitude_DDS); Since all three fields are used in the query, I am curious if that would help in any way. Doesn´t

Re: [sqlite] How to speed up my queries?

-- Christophe Leske www.multimedial.de - [EMAIL PROTECTED] http://www.linkedin.com/in/multimedial Lessingstr. 5 - 40227 Duesseldorf - Germany 0211 261 32 12 - 0177 249 70 31 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin

[sqlite] What is quicker?

? -- Christophe Leske www.multimedial.de - [EMAIL PROTECTED] http://www.linkedin.com/in/multimedial Lessingstr. 5 - 40227 Duesseldorf - Germany 0211 261 32 12 - 0177 249 70 31 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin

Re: [sqlite] What is quicker?

version? Or does anyone have a precompiled DLL binary for me? Any help is much appreciated -- Christophe Leske www.multimedial.de - [EMAIL PROTECTED] http://www.linkedin.com/in/multimedial Lessingstr. 5 - 40227 Duesseldorf - Germany 0211 261 32 12 - 0177 249 70 31

Re: [sqlite] What is quicker?

. Is there any document that would show some steps on how to compile the source for Windows in order to create an extension? I am sorry, but i am complete newbie to Sqlite's source. But SQLite rocks! -- Christophe Leske www.multimedial.de - [EMAIL PROTECTED] http://www.linkedin.com

Re: [sqlite] What is quicker?

the source ZIP and the rtree files pointed out by Dr Hipp. I am targeting Windows XP, single processor, and using Visual Studio 2005, but i am not bound to this if there are better options. I just got something by setting up a simpe project in Visual Studio 2005. Christophe Leske

Re: [sqlite] What is quicker?

Sorry, I was too quick - i now got a 80Kb rtree.dll file which seems fine. I will test it. Thanks to everyone for your support, Christophe Leske www.multimedial.de - [EMAIL PROTECTED] http://www.linkedin.com/in/multimedial Lessingstr. 5 - 40227 Duesseldorf - Germany 0211 261 32 12 - 0177 249

Re: [sqlite] What is quicker?

wurde nicht gefunden. The last sentence says that the specified procedure can´t be found. Any help is much appreciated - again, i am on Windows, using Visual Studio 2005. Thanks and greets, Christophe Leske www.multimedial.de - [EMAIL PROTECTED] http://www.linkedin.com/in/multimedial

Re: [sqlite] What is quicker?

of switching to an RTree index) using a query like this. Thank you very much, that was very helpful and informative. I will do so. Thnks again, Christophe Leske www.multimedial.de - [EMAIL PROTECTED] http://www.linkedin.com/in/multimedial Lessingstr. 5 - 40227 Duesseldorf - Germany 0211 261 32 12

Re: [sqlite] What is quicker?

how we can this thing to work with my data ... Thank you, Christophe Leske www.multimedial.de - [EMAIL PROTECTED] http://www.linkedin.com/in/multimedial Lessingstr. 5 - 40227 Duesseldorf - Germany 0211 261 32 12 - 0177 249 70 31 ___ sqlite-users

[sqlite] rtree extension to use with my data

this table for queries? I reckon I would further use the IDs I got back from the query to look up the corresponding records in my normal table, right? Something like select * from cities where cities.id=(select id from cityLookUp where ??? Long and Lat clause) -- Christophe Leske

Re: [sqlite] rtree extension to use with my data

only cities for the time being! Does it make sense to use rtree then? Sorry if i am abusing the help of this list - I like SQlite and have studied it for personal pleasure so far, but I am by all means no database expert. Greets, Christophe Leske www.multimedial.de - [EMAIL PROTECTED] http

Re: [sqlite] What is quicker?

(a country like france for instance), as well as very small areas (maximum zoom). I added an index on the ID field for the search in the city database, that helped a bit, but i am dissapointed that the rtree search is not faster than the normal search for bigger areas... -- Christophe Leske

Re: [sqlite] What is quicker?

citylookup where (citylookup.longitude_min21.477932 and citylookup.longitude_max29.315407) and (citylookup.latitude_min40.614945 and citylookup.latitude_max44.657669)) and cities.class_dds6 order by class_dds limit 80 -- 36 -- Christophe Leske www.multimedial.de - [EMAIL PROTECTED] http

[sqlite] Any SQLite GUI application that can handle SQlite files with extension tables?

Hi, every SQlite file that has extension files in it is being reported to me by SQLite Database Browser as being empty. Is there any GUI app on Windows that can handle databases which have extension tables in it? -- Christophe Leske www.multimedial.de - [EMAIL PROTECTED] http

Re: [sqlite] What is quicker?

for its position (which i need to position a label). -- Christophe Leske www.multimedial.de - [EMAIL PROTECTED] http://www.linkedin.com/in/multimedial Lessingstr. 5 - 40227 Duesseldorf - Germany 0211 261 32 12 - 0177 249 70 31 ___ sqlite-users mailing

Re: [sqlite] What is quicker?

i better duplicate the lat/long data then in my city table. Uh, i am never satisfied! :-) -- Christophe Leske www.multimedial.de - [EMAIL PROTECTED] http://www.linkedin.com/in/multimedial Lessingstr. 5 - 40227 Duesseldorf - Germany 0211 261 32 12 - 0177 249 70 31

Re: [sqlite] transaction recovery question

set PRAGME CACHE as well... Thanks in advance, -- Christophe Leske www.multimedial.de - [EMAIL PROTECTED] http://www.linkedin.com/in/multimedial Lessingstr. 5 - 40227 Duesseldorf - Germany 0211 261 32 12 - 0177 249 70 31 ___ sqlite-users mailing list

Re: [sqlite] transaction recovery question

away, thanks, Christophe Leske www.multimedial.de - [EMAIL PROTECTED] http://www.linkedin.com/in/multimedial Lessingstr. 5 - 40227 Duesseldorf - Germany 0211 261 32 12 - 0177 249 70 31 ___ sqlite-users mailing list sqlite-users@sqlite.org http

[sqlite] How to speed up my queries?

on how to analyze my queries. I should probably do that, yet i am unfamiliar with reading the output of the Explain command. Thanks for your time and eventual help, -- Christophe Leske www.multimedial.de - [EMAIL PROTECTED] http://www.linkedin.com/in/multimedial Lessingstr. 5 - 40227 Duesseldorf

Re: [sqlite] How to speed up my queries?

Goto 0 11000 -- Christophe Leske www.multimedial.de - [EMAIL PROTECTED] http://www.linkedin.com/in/multimedial Lessingstr. 5 - 40227 Duesseldorf - Germany 0211 261 32 12 - 0177 249 70 31 ___ sqlite-users mailing