AIL PROTECTED]>
Date: Sunday, July 29, 2007 8:06 pm
Subject: [sqlite] Re: Transaction Check
> RaghavendraK 70574
> <[EMAIL PROTECTED]> wrote:
> > If the sqlite file is deleted at runtime and if there are any open
> > connections,can these connections detect and return error?
>
RaghavendraK 70574
<[EMAIL PROTECTED]> wrote:
If the sqlite file is deleted at runtime and if there are any open
connections,can these connections detect and return error?
On Windows, you simply cannot delete a file that is open by somebody
else. DeleteFile call returns an error.
On Linux,
Hello Dave,
Well, if you have users with really odd performance issues. I mean
orders of magnitude slower than you expect. I've found it's either AV
software, Norton in particular will crush PC performance or external
USB hard disks/memory sticks. That's become the first question I ask
any more
Slightly off-topic for this list, but antivirus and firewall
software is a plague that is bad and going to get worse. In
effect, antivirus software is a security guard that randomly
shoots "suspicious" members of the public.
Thanks Igor, much obliged. That fits my application quite elegantly.
Igor Tandetnik wrote:
John Stanton <[EMAIL PROTECTED]> wrote:
I want to store multi-statement SQL to implement an entire transaction
in the form -
BEGIN
statement
statement
...
COMMIT
I can see that
John Stanton <[EMAIL PROTECTED]> wrote:
I want to store multi-statement SQL to implement an entire transaction
in the form -
BEGIN
statement
statement
...
COMMIT
I can see that sqlite3_prepare has the capability of stepping through
a multi statement string but it looks
mithin <[EMAIL PROTECTED]> wrote:
I have a CSV file that needs to be imported into a SQLite database
and the contents of the CSV file should be inserted into various
tables of the database.
1. Will using transaction speed up this opeartion of import?
Yes. Perform all the insertions within a
7 matches
Mail list logo