Re: [sqlite] sqlite3_step performance degredation

There was a recent SQLite bug that caused the size of the SQLite cache to shrink in some circumstances, and the longer a program ran, the smaller the cache became. Maybe you are running into this bug. IIRC, you had to do an update in the select loop to trigger the bug, so if you're not doing

Re: [sqlite] sqlite3_step performance degredation

On 15 Jun 2009, at 10:11pm, Mike Borland wrote: > > When I start the 900 read iterations (always in the same order), the > first one generally reads in about 50ms and by the last read, it's > taking roughly 1000ms. Sometimes it slows down immediately, > sometimes after the 100th

Re: [sqlite] sqlite3_step performance degredation

Also is there an index on the table B.ID field? --- On Mon, 6/15/09, Mike Borland wrote: > From: Mike Borland > Subject: Re: [sqlite] sqlite3_step performance degredation > To: "General Discussion of SQLite Database"

Re: [sqlite] sqlite3_step performance degredation

Mike, Not 100% sure of the prior information but a write could slow things down. It would basically gain the lock to the DB preventing the reads from happening. But it should not be permanent. If you are reading all of the data. Could you just execute one query instead of iterating over

Re: [sqlite] sqlite3_step performance degredation

Nuno, unfortunately your psychic skills are a bit off on this one. Sorry I wasn't more explicit. I am not using any LIMIT or OFFSET to do any virtual scrolling. Basically I have table A which has 900 rows. Table B has 180,000 rows (900 * 200) which has a foreign key relationship back to

Re: [sqlite] Query regarding downloading 3.2.2 version of Sqlite

Heya, search for sqlite-3_2_2.zip or sqlitedll-3_2_2.zip ( http://www.ponx.org/download/CD/Python/sqlitedll-3_2_2.zip) on Google. They're no longer available from the official site. Alternatively you can checkout the correct version from SQLite CVS and compile it yourself. Best regards, Filip

Re: [sqlite] Lemon parser : compile error when using "%token_destructor" directive

Very interesting. I had no idea that lemon.c and lempar.c were being revised. I assumed they were static. Would it be too much to increment the version that lemon -x prints? Currently it prints out "Lemon version 1.0" which led me to believe it was not being actively developed. RW P.S. I

Re: [sqlite] How to how many memory is used by sqlite

On Jun 15, 2009, at 9:04 AM, pierr wrote: > > Hi all, > I am using an memory type sqlite database in our embedded > application. After the applicate run a while ,the system will run > ourt of > out of memory. So, is there a way to know how many memory is used by > sqlite? > That would

Re: [sqlite] Lemon parser : compile error when using "%token_destructor" directive

On Mon, Jun 15, 2009 at 11:42:26AM -0400, Wilson, Ron P wrote: || It has been a while since I used lemon (big fan though). Did you resolve || this issue or do you still need help? [It appears my previous response did not get through.] Looks suspiciously like this problem, which was fixed in

Re: [sqlite] How to how many memory is used by sqlite

On 15 Jun 2009, at 2:04pm, pierr wrote: > I am using an memory type sqlite database in our embedded > application. After the applicate run a while ,the system will run > ourt of > out of memory. Does the memory usage grow slowly all the time, or does it get bigger very suddenly ?

Re: [sqlite] Issue with Distinct and Large numbers

On Jun 15, 2009, at 11:38 AM, lmoug...@rockwellcollins.com wrote: > > Thanks for your quick response, > > We're using SqLite version 2.8.15 to be exact, is there a known > issue with this version and its ability to maintain data types? > > Previously we had considered upgrading to 3.x but that

Re: [sqlite] Lemon parser : compile error when using "%token_destructor" directive

It has been a while since I used lemon (big fan though). Did you resolve this issue or do you still need help? RW Ron Wilson, Engineering Project Lead, 434.455.6453 HARRIS CORPORATION | RF Communications Division assuredcommunications(tm) -Original Message- From:

Re: [sqlite] SPHiveDB: A server for sqlite database.

"lau stephen" schrieb im Newsbeitrag news:c26a05160906150443h44b8f434s46e6ab4215f61...@mail.gmail.com... 2009/6/14 Olaf Schmidt : >> Each client could do (with a 1:10 relation of writes and reads) >> >> Loop 1000 times >> With LoopCounter Modulo 7

Re: [sqlite] Database logic in TRIGGER and CONFLICT, or in software ?

Jay, Every system that uses a database must deal with this problem, and there are no real easy answers. But here are a few deeper points to consider ... Beautifully written!! Malcolm ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] SQlite3 - SQL injection using ruby

dave lilley wrote: > Many thanks John so if i take that example and push it out so i can have 1 > method that can return a SQL select statement on any table, field and search > criteria i would only need to do this? > > In ruby it would be > > make_SQL (table, field, criteria) >stmt =

Re: [sqlite] SQlite3 - SQL injection using ruby

On Mon, Jun 15, 2009 at 07:09:44PM +1200, dave lilley scratched on the wall: > >>e.g. stmt = "select * from customers where cust_no = #{uservar}" > >> row = db.execute(stmt) > > Now i could understand how my code could possibly allow the records in the > table to be deleted but what's the

[sqlite] How to how many memory is used by sqlite

Hi all, I am using an memory type sqlite database in our embedded application. After the applicate run a while ,the system will run ourt of out of memory. So, is there a way to know how many memory is used by sqlite? That would include the memory for page cache , any other other internal

Re: [sqlite] SQlite3 - SQL injection using ruby

dave lilley wrote: > Sorry for posting twice but... > > how does the method you have given me differ to mine? > > eg lets say this is the scenario > > uservar = "delete * from customers where * = *" > > >>> e.g. stmt = "select * from customers where cust_no = #{uservar}" >>> row =

Re: [sqlite] SPHiveDB: A server for sqlite database.

2009/6/14 Olaf Schmidt : > Interesting approach - (such a mem-vfs offers some nice > options at the serverside, once it is done). > > Did you already tested, how the whole approach behaves > in concurrency-scenarios with e.g. only 4-8 concurrent clients? > Using your schema,

Re: [sqlite] SQlite3 - SQL injection using ruby

dave lilley wrote: > Sorry for posting twice but... > > how does the method you have given me differ to mine? > > eg lets say this is the scenario > > uservar = "delete * from customers where * = *" > > >>> e.g. stmt = "select * from customers where cust_no = #{uservar}" >>> row =

Re: [sqlite] how to build TCL testing environment

Hello, you can either install a Tcl distribution like ActiveState's (www.activestate.com) or use a tclkit - a standalone Tcl executable (see: http://code.google.com/p/tclkit/) Regards, Arjen On 2009-06-15 08:27, ??? wrote: > Hello,Everyone > I just have a project based on SQLite.For some

Re: [sqlite] SQlite3 - SQL injection using ruby

Sorry for posting twice but... how does the method you have given me differ to mine? eg lets say this is the scenario uservar = "delete * from customers where * = *" >>e.g. stmt = "select * from customers where cust_no = #{uservar}" >> row = db.execute(stmt) Now i could understand how my

Re: [sqlite] SQlite3 - SQL injection using ruby

Many thanks John so if i take that example and push it out so i can have 1 method that can return a SQL select statement on any table, field and search criteria i would only need to do this? In ruby it would be make_SQL (table, field, criteria) stmt = "select * from #{table} where

Re: [sqlite] Parsing line output (Was: How does SQLite handle newlines in values?)

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Florian v. Savigny wrote: > I was completely aware it is not intended as > the standard way for programs to access an SQLite database, Yes, this isn't documented as such but DRH does mention it now and then. However if you look at the SQLite web

[sqlite] how to build TCL testing environment

Hello,Everyone I just have a project based on SQLite.For some reasons, I have to change SQLite source code to cater for our requirement . There are a lot of TCL Testing cases in the SQLite. So I want to configure the testing environment in the Windows Operation System to test by TCL

Re: [sqlite] Database logic in TRIGGER and CONFLICT, or in software ?

Very well said. Harold Wood & Meyuni Gani -Original Message- From: Jay A. Kreibich Sent: Sunday, June 14, 2009 8:44 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] Database logic in TRIGGER and CONFLICT, or in software ?