Re: [sqlite] Question about searches

i need a generic solution if possivble. All i can see so far is to build a table of all special characters ever used in the 24000 names of cities which make problems and remap them accordingly. -- Christophe Leske www.multimedial.de - i...@multimedial.de http://www.linkedin.com/in/multimedia

[sqlite] Question about searches

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 Leske www.multimedial.de - i...@multimedial.de http://www.linkedin.com/in/multimedial Lessingstr. 5 - 40227

Re: [sqlite] Sample file search algorithm

less you put them 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 nu

Re: [sqlite] SQLite version 3.6.10 - Warning

I can provide further 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 __

Re: [sqlite] SQLite version 3.6.10 - Warning

uot; sqlite> .s sqlite> .s cl1; sqlite> We also experience crashes with the new version, 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 unders

Re: [sqlite] SQLite version 3.6.10

supposed to do. I think 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

Re: [sqlite] SQLite version 3.6.10 - Warning

uot; sqlite> .s sqlite> .s cl1; sqlite> We also experience crashes with the new version, 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 underst

Re: [sqlite] SQLite version 3.6.10 - Warning

ning off my project, 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 mailin

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 Duess

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

[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.multimedi

[sqlite] contstraint failed problem

use one of the records 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:/

Re: [sqlite] optimizing a multiple select statement

t;53.23 and lama<53.23); > Thanks, but sometimes it says "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] optimizing a multiple select statement

and lami>53.23 and lama<53.23) and id not in (select id from idlookup) ) ? -- 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

omit the ID field. 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] Problems using AUTOINCREMENT row IDs in indexes

Don't > do 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 1

[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] Another set of questions

ing, yet to a target "system" which is at my client´s site through educated 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 ___

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

Re: [sqlite] Another set of questions

everything is working, then work slowly > and carefully 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://

Re: [sqlite] Two questions

ed amongst tables in such a way that the data is there only once, thus creating 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 -

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

Re: [sqlite] Another set of questions

le). This is all fine 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/multim

[sqlite] Another set of questions

rebuilding it. Am 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@sqlit

[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

Re: [sqlite] Condition on several tables

the big cities (c2) and the not so big cities (c3) 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.

Re: [sqlite] Condition on several tables

ately > and then UNION them together, 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/

[sqlite] Condition on several tables

ave 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

[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

Re: [sqlite] Size of a memory DB?

ory database 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

[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] 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 PROTEC

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 PROTEC

Re: [sqlite] Compressing read-only dbs?

hould have said that, I am sorry). CramFS 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 - German

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

[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] How to speed up read-only databases?

s fine, no problem, but it does 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 Duesseld

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

f the call change all the time? -- 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-user

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

ers Nope, just one from DVD. Thanks again, -- 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 sqli

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

those > columns as INDEXed, 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-indexe

[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)

ne interpreter does not correctly handle diacritic characters, or my sqlite 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 Lessing

[sqlite] Like statement and Unicode support

Windows XP and ideally 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 ___ sq

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 - [EMA

Re: [sqlite] Ambigous column

iso=countries.iso; > Yes, 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 -

[sqlite] Ambigous column

e ISO from 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

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

Re: [sqlite] rtree extension question

ze, like 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 PROTEC

Re: [sqlite] rtree extension question

Select * from rtree where longitude>longitude_minimal and longitudelatitude_minimal and latitude<latitude_maximal? Would that actually work? Christophe Leske www.multimedial.de - [EMAIL PROTECTED] http://www.linkedin.com/in/multimedial Lessingstr. 5 - 40227 Duesseldorf - Germany 0211

[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-users

[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] What is quicker?

is slow as hell.. so 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 -

Re: [sqlite] What is quicker?

.latitude_min>-45.11050 2 and citylookup.latitude_max<44.889498)) and cities.class_dds<2 order by class_ dds limit 50; However, this doesn´t give me the city with the longitude and latitude for its position (which i need to position a label). -- Christophe Lesk

[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?

tude_min>21.477932 and citylookup.longitude_max<29.315407) and (citylookup.latitude_min>40.614945 and citylookup.latitude_max<44.657669)) and cities.class_dds<6 order by class_dds limit 80" -- 36 -- Christophe Leske www.multimedial.de - [EMAIL PROTECTED] http://www.linkedin.com/in

Re: [sqlite] What is quicker?

derable ones for small areas (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 ar

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

lat and > long twice. > Well, my database holds 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, C

[sqlite] rtree extension to use with my data

use 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 Le

Re: [sqlite] What is quicker?

u, I got it to work!!! Now, let´s see 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

Re: [sqlite] What is quicker?

ll get the best results (short 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.

Re: [sqlite] What is quicker?

ons sqlite> .load rtree.dll Die angegebene Prozedur 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

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?

Windows, and I got myself 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.

Re: [sqlite] What is quicker?

for this, i got the files. 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://w

Re: [sqlite] What is quicker?

Besides, how do I recompile the current 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

[sqlite] What is quicker?

and latitude_dds<44.424779) ORDER BY class_dds ASC Limit 20 Would that be quicker eventually? -- 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?

9" -- 11 -- "TIME for <> statement without ORDER BY-clause:991" -- 11 a 2 field index (longitude, latitude): -- "TIME for Between statement:10" -- 11 -- "TIME for <> statement:11" -- 11 -- "TIME for <> statement without ORDER BY-clause:10&quo

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 curio

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

-- 11 two indices (longitude and latitude separetely): -- "TIME for Between statement:2786" -- 11 -- "TIME for <> statement:2792" -- 11 A 3 field index (class_dds, latitude_dds, longitude_dds): -- "TIME for Between statement:2783" -- 11 -- "TIME for <> s

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

('Ferrere',6,-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.

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

o substantial speed gain to be found - 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 26

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

your time, -- 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:808

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

ct from a 40Mb Sqlite 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 mail

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

leLock 0 3 0 Cities 00 46Goto 0 110 00 -- 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] How to speed up my queries?

ist 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 Duesseld

Re: [sqlite] transaction recovery question

a new thread right 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@sql

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