In the 2.8 series, an ATTACH command does not honor a specified busy-timeout
value; rather, if the database which is being attached is locked, the ATTACH
fails immediately. It would seem that ATTACH should honor busy-timeout as do
other commands, and retry until it succeeds or the timeout is
At 2:07 PM +0100 6/24/04, Chris Ulliott wrote:
Hi all,
I am using the SQLite DB with MS VC++ v 6. In the code below you can see
I am looping around a ODBC connection to an access database and I am
inserting those records into my new SQLite database. My problem is
SQLite.dll causes an access
At 3:35 AM -0700 6/24/04, Daniel K wrote:
Fortunately the only file format issue here is whether
or not the 'affinity mode' is a persistent property
of the database.
True. And a persistent property is definately what I want.
Otherwise, someone may simply open the file the wrong way some day
and
But I am really like in my testing result.
I did 15 M insert in maybe 10 transaction and I am really happy with the
performance.
I did not use any long filed as index.
-Original Message-
From: D. Richard Hipp [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 24, 2004 3:13 PM
Cc: [EMAIL
Thanks you for all of the ideas. Here are answers to the various questions:
1) Currently, I am committing after every 10,000 inserts. Initially, I was
running all of the inserts of a set (25,000+ records) in one transaction. I
found that I was able to improve performance slightly by committing
Julian Brierley ([EMAIL PROTECTED]) wrote:
> Hans-Juergen Taenzer wrote:
>> doing some tests with the new version, I have encountered a
>> problem:
>>
>> void testva(void)
>> {
>>char *s;
>>unsigned long ul1 = 0x7FFF;
>>unsigned long ul2 = 0x;
>>
>>s =
As mentioned before try with putting all your inserts into
begin end block. In that way there is no way to query the
file from other proces. Any way check pragma directives ie.
make bigger cache size...
--
Regards,
Michał Zaborowski (TeXXaS)
Wempa, Kristofer (Kris), ALABS wrote:
-Original Message-
From: Soham Mehta [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 24, 2004 3:22 PM
To: [EMAIL PROTECTED]
Subject: [sqlite] Performance Issue with SQLite Inserts
Hello,
Obviously, this does not match up with the performance tests that
Soham Mehta wrote:
Hello,
We recently switched to SQLite in our application and have not been able to
get the performance that partially motivated the switch. Our application
downloads TV guide data from the internet and loads it into a local
database.
Obviously, this does not match up with
-Original Message-
From: Soham Mehta [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 24, 2004 3:22 PM
To: [EMAIL PROTECTED]
Subject: [sqlite] Performance Issue with SQLite Inserts
Hello,
We recently switched to SQLite in our application and have not been able
to
get the performance
Hello,
We recently switched to SQLite in our application and have not been able to
get the performance that partially motivated the switch. Our application
downloads TV guide data from the internet and loads it into a local
database.
The data is in 6 sets of XML files (each set holds 2
To make the dll, I could not get the dllwrap to work. Based on:
http://www.neuro.gatech.edu/users/cwilson/cygutils/dll-stuff/README
I used this script to create the dll.
#!/bin/sh
gcc -mno-cygwin -Wl,--base-file,base.tmp \
-mdll -Wl,-e,[EMAIL PROTECTED] \
-o sqlite3.dll *.o -L/lib/mingw
nathanvi wrote:
Thanks. Do you know how can i teach to my application (phpsqliteadmin
and sqlitebrowser-GUI) the result set is utf8 and it is not iso8859-1?
I'm sorry. I don't know that. Maybe the authors of these tools know how
to solve your problem?
At least for the PHP stuff I guess it's
Chris Ulliott wrote:
Andy!
FANTASTIC JOB! Thank you! Could you also make the source available
please and tell me what changes you made? In the future if a new version
comes out, it may not include your change and I need it!
I would hate to upgrade and loose your change...
Thanks again, Great
Andy!
FANTASTIC JOB! Thank you! Could you also make the source available
please and tell me what changes you made? In the future if a new version
comes out, it may not include your change and I need it!
I would hate to upgrade and loose your change...
Thanks again, Great work!
Chris
Hans-Juergen Taenzer wrote:
hello,
doing some tests with the new version, I have encountered a problem:
void testva(void)
{
char *s;
unsigned long ul1 = 0x7FFF;
unsigned long ul2 = 0x;
s = sqlite3_mprintf("%lu", ul1);
printf("ul1: %lx, %s\n", ul1, s);
s =
Chris Ulliott wrote:
Hi All,
I have downloaded from the downloads page the DLL (Sqlite.dll) for
Windows. I have written some code using the API and everything was going
great until I needed to do an execute and it came to my attention that
the DLL does not export sqlite3_exec
Does anybody have
Hi Richard
Unfortionatly there is no link for a Compiled Binary (win 32) for
version 2.x on the downloads page otherwise I would be using it.
Thanks for replying.
Chris
Richard Boehme wrote:
The regular sqlite.dll should be the 2.X release, not the 3 release, and
therefore won't
hello,
doing some tests with the new version, I have encountered a problem:
void testva(void)
{
char *s;
unsigned long ul1 = 0x7FFF;
unsigned long ul2 = 0x;
s = sqlite3_mprintf("%lu", ul1);
printf("ul1: %lx, %s\n", ul1, s);
s = sqlite3_mprintf("%lu", ul2);
The regular sqlite.dll should be the 2.X release, not the 3 release, and
therefore won't export sqlite3_exec, but will export sqlite_exec.
As for the other, I haven't played around with sqlite3 much as I'm in
the middle of a project, but I intend to in a couple of days.
Thank you.
Richard
Hi all,
I am using the SQLite DB with MS VC++ v 6. In the code below you can see
I am looping around a ODBC connection to an access database and I am
inserting those records into my new SQLite database. My problem is
SQLite.dll causes an access violation after inserting about 190 records.
Does
nathanvi wrote:
Strings are in utf8 encoding.
My system has utf8 locales too.
I've a lot of problem with accents as èéàòù.
I inserted them in a field.
When i make a select of that field, i obtain right accents via shell:
sqlite db.sqlite 'select frase from logchan limit 16660' => èéàòù
On the
G'day,
I thought I'd so somewhat of a code review on the lower-level pieces of
sqlite 3.0.1, so here goes:
v- code review v
You use a loop here to try and write all data
synchronously to disk. I had to read it a couple of times before I
realised it was
This is pretty much what strict affinity is meant to
do. But alas, time has slipped away faster than anyone
thought possible and it may not make it into the
release at the end of the month.
Fortunately the only file format issue here is whether
or not the 'affinity mode' is a persistent property
> In brief, I want an option that is like "normal" except that an error
> is returned if the data can not be converted to the column's declared
> type; I want some input flexibility, but I don't want the engine to
> store values that are not of the correct type.
I second this wish.
Frank
Hello,
"D. Richard Hipp" <[EMAIL PROTECTED]>
24/06/2004 06:04 AM
To:
cc: [EMAIL PROTECTED]
Subject:Re: [sqlite] database corruption
> Michael Robinette wrote:
> > ...
> You present a new and novel approach to corrupting the database, which
> is to
26 matches
Mail list logo
