Re: [sqlite] Multithreading

Well, currently SQLite seems to meet my performance needs. Currently I don't think that brewing my own file format would pay off. I will consider this only as a last solution. I was being somewhat facetious mainly to prove that you don't actually want best possible performance. You are far

[sqlite] SQLITE_IOERR and strange rollback when db is busy

Hello, I stumbled over some quite strange case. Here's the easiest test case that triggers the behaviour: One process performs very long reads from a db (multiple joins, so the cartesian product is *very* large, and the reader needs a while to complete). Another process performs a "BEGIN

Re: [sqlite] Multithreading

Hello Roger, thanks for your answer. Answers inline. Roger Binns wrote: itself. However, I'm afraid that this will not lead to the best possible performance. If you want the best possible performance then don't use SQLite at all and instead make your own file format that exactly meets your

Re: [sqlite] php4/sqlite - sqlite_escape_string doesn't function

Peter Jay Salzman wrote: Hi all, This piece of code kept giving error messages that looked like some of my VALUES were getting parsed by php: sqlite_query( $handle, " INSERT INTO course VALUES ( sqlite_escape_string($semester),

Re: [sqlite] Multithreading

itself. However, I'm afraid that this will not lead to the best possible performance. If you want the best possible performance then don't use SQLite at all and instead make your own file format that exactly meets your needs and tradeoffs (memory, byte ordering, CPU, concurrency etc). result to

[sqlite] Multithreading

Hello All, I'm sure this questions has already been asked thousands of times, but after searching the archive I still don't know the definite answer. Is it safe to access the same instance of an sqlite3 database (the same pointer returned by sqlite3_open) in several threads, provided that the

Re: [sqlite] sqlite3_open() exclusive?

On Fri, Dec 24, 2004 at 07:32:07PM -0500, John Richard Moser wrote: > I thought sqlite databases weren't supposed to be opened with two sqlite > processes at once. There are unimplemented locking commands due to this > right? > > I'm bouncing back and forth in my head trying to decide if I

Re: [sqlite] php4/sqlite - sqlite_escape_string doesn't function

Roger Binns wrote: sqlite_query($handle, "INSERT INTO course VALUES (?,?,?,?,?)", array($semester, $course, $course_desc, $college, $reference)) Jolan Luff wrote: sqlite_query($db, "INSERT INTO whints (whid, whregex, " . "whcatid) VALUES (NULL, '" . sqlite_escape_string($val) . "', '"