RE: [sqlite] BEGIN & COMMIT: useful for SELECT?

To: sqlite-users@sqlite.org Subject: Re: [sqlite] BEGIN & COMMIT: useful for SELECT? Does anyone have any sample code on doing transactions in sqllite, and know of a website where I can read up oh how transactions work? Thanks Steve D. Richard Hipp wrote: >On Thu, 2005-05-12 at 15:19

[sqlite] BEGIN & COMMIT: useful for SELECT?

Hi! That's probably a no brainer for you guys but are transactions only useful for when we're writting or updating the database? Buy using transactions when fetching data, do I improve anything or I shouldn't do that? Thanks! Luc

RE: [sqlite] Write issues on some computers?

What if the database was not closed properly on exit, would that be enough to set the database to read-only? Luc Vandal Edovia Technologies Inc. [EMAIL PROTECTED] www.edovia.com -Original Message- From: Clay Dowling [mailto:[EMAIL PROTECTED] Sent: February 24, 2005 11:43 AM To

RE: [sqlite] Write issues on some computers?

et" the db? Luc Vandal Edovia Technologies Inc. [EMAIL PROTECTED] www.edovia.com -Original Message- From: Clay Dowling [mailto:[EMAIL PROTECTED] Sent: February 23, 2005 1:22 PM To: sqlite-users@sqlite.org Subject: RE: [sqlite] Write issues on some computers? Luc Vandal said: &g

RE: [sqlite] Write issues on some computers?

Hello Clay, The database is stored in the [User]\Local Settings\Application Data\ folder for the current user. Thanks for your help! Luc Vandal Edovia Technologies Inc. [EMAIL PROTECTED] www.edovia.com -Original Message- From: Clay Dowling [mailto:[EMAIL PROTECTED] Sent: February

RE: [sqlite] Write issues on some computers?

Could the problem be MSVCRT.DLL? Luc Vandal Edovia Technologies Inc. [EMAIL PROTECTED] www.edovia.com -Original Message- From: Luc Vandal [mailto:[EMAIL PROTECTED] Sent: February 23, 2005 9:12 AM To: sqlite-users@sqlite.org Subject: [sqlite] Write issues on some computers? Hi

RE: [sqlite] Write issues on some computers?

By the way, we use transactions (BEGIN; COMMIT;) Luc Vandal Edovia Technologies Inc. [EMAIL PROTECTED] www.edovia.com -Original Message- From: Luc Vandal [mailto:[EMAIL PROTECTED] Sent: February 23, 2005 9:12 AM To: sqlite-users@sqlite.org Subject: [sqlite] Write issues on some

[sqlite] Write issues on some computers?

s settings, etc.) that could cause this? I really can't see what in our code would cause that. Are there some requirements for SQLite? Thanks, Luc Vandal Edovia Technologies Inc. [EMAIL PROTECTED] www.edovia.com

[sqlite] VACUUM question

of times during the day so that loading time of the other app (the plugin) would be faster. Also, what if, while doing a VACUUM, a query executes on the database? Will it just fail? Thanks! Luc Vandal Edovia Technologies Inc. [EMAIL PROTECTED] www.edovia.com

RE: [sqlite] UPDATE query: why is that code sooo slow?

From: Scott Wilkinson [mailto:[EMAIL PROTECTED] Sent: January 22, 2005 12:14 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] UPDATE query: why is that code sooo slow? Luc Vandal wrote: >Hi, > >Perhaps I'm not doing things correctly, but this code will take about 1 >minute t

[sqlite] UPDATE query: why is that code sooo slow?

Hi, Perhaps I’m not doing things correctly, but this code will take about 1 minute to execute (2400 records on a total of around 44000 records): Basically, I’m getting records that need to be updated. Then, I go through each record and update it. Should be fast IMHO but I don’t see why it’s that