Hello Richard,
I set the busy timeout to zero and manage the errors in my code with
delays and retries. What I found is I couldn't pick a busy timeout
value that was always correct.
Friday, November 28, 2008, 8:12:06 PM, you wrote:
RK> Hi Alexey,
RK> Thanks for your link, but it is not really
Hi Alexey,
Thanks for your link, but it is not really click me too well
I should set this busy_timeout to longer ms than current ?
Richard K
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Alexey Pechnikov
Sent: Friday, November 28, 2008 3:00 PM
To: Ge
Hello!
В сообщении от Saturday 29 November 2008 01:16:17 Richard Kim написал(а):
> We have database table, and it is being written, sometimes 30 times a
> second.
> Some of the data succeeded, but some aren't.
>
> How should we handle this sort of lock issue ?
http://www.sqlite.org/c3ref/bus
Hi,
We have database table, and it is being written, sometimes 30 times a
second.
Some of the data succeeded, but some aren't.
How should we handle this sort of lock issue ?
thanks
Richard K
___
sqlite-users mailing list
sqlite-users@sqlite.org
On 11/28/08, tom_slee <[EMAIL PROTECTED]> wrote:
>
> I used the Numerical python package and its types don't always behave well
> with other python variables - I had to insert into sqlite by piecing
> togethera literal SQL statement rather than binding the variables. So no
> doubt you are right
I used the Numerical python package and its types don't always behave well
with other python variables - I had to insert into sqlite by piecing
togethera literal SQL statement rather than binding the variables. So no
doubt you are right and the problem is related to the number of digits or
the typ
Hi, Tom,
Regarding: "Adding values to att0 (one of the numeric columns) gives
this odd result:"
I tried this on win xp 32 using the sqlite3.exe command-line interface
and for me it *does* behave as expected.
I tried it under sqlite 3.5.5 and under 3.6.6.2.
I wonder if PHP (or something) is
This seems basic, so please excuse me if it is a common question.
I have a table defined like this:
CREATE TABLE map (
runID INT, type TEXT, itemID int,
att0 NUMERIC, att1 NUMERIC, PRIMARY KEY ( runID, type, itemID )
);
Here are the first four rows:
1|c|0|0.029053
It's working, Thank you!
Igor Tandetnik wrote:
>
> "Tommy Anderson" <[EMAIL PROTECTED]>
> wrote in message news:[EMAIL PROTECTED]
>> Select * From ExcelMapValue
>>
>> OUTER JOIN (SELECT ProjectId, InputId, DataValue, Formula
>> FROM ProjectData
>> WHERE (ProjectId = @Id)) de
On Nov 28, 2008, at 8:13 AM, Simon Bulman wrote:
> Ok, I am having trouble counting this morning.
>
> No of rows in Table 1: 1165
> No of rows in Table 2: 376295
>
> Analysis is attached.
>
> Sorry for the continued confusion.
The SUMMARY_VECTORS table consumes 99.55% of the file. I assume that
Ok, I am having trouble counting this morning.
No of rows in Table 1: 1165
No of rows in Table 2: 376295
Analysis is attached.
Sorry for the continued confusion.
Cheers,
S.
-Original Message-
From: Jens Miltner [mailto:[EMAIL PROTECTED]
Sent: 28 November 2008 12:58
To: [EMAIL PROTECTE
On Nov 28, 2008, at 7:37 AM, Simon Bulman wrote:
> Ahhh, sorry, I wrongly calculated the number of rows in table 2. It
> actually
> has 29581 rows. Still surprised at the 7x size increase but perhaps
> you are
> not based on the overheads?
The overhead should typically be about 20% or less -
Am 28.11.2008 um 13:37 schrieb Simon Bulman:
> Ahhh, sorry, I wrongly calculated the number of rows in table 2. It
> actually
> has 29581 rows. Still surprised at the 7x size increase but perhaps
> you are
> not based on the overheads?
I still can't reproduce your database sizes - creating 3
Ahhh, sorry, I wrongly calculated the number of rows in table 2. It actually
has 29581 rows. Still surprised at the 7x size increase but perhaps you are
not based on the overheads?
Sorry for the misleading info,
Cheers,
S.
-Original Message-
From: Jens Miltner [mailto:[EMAIL PROTECTED]
Download the sqlite3_analyzer.exe utility from the SQLite website
(http://www.sqlite.org/download.html
) and run it against your database file. The output will tell you
where the disk space is being used. You might want to post the output
to this list.
D. Richard Hipp
[EMAIL PROTECTED]
Done, it works :-)
DEF file was the one that had been missing for a long time :(
Thank you Mike.
Ti Ny
> From: [EMAIL PROTECTED]
> To: sqlite-users@sqlite.org
> Date: Fri, 28 Nov 2008 11:28:34 +0100
> Subject: Re: [sqlite] sqlite3_open16 fails on Windows Vista 64b
>
> Use the one included in
Use the one included in this archive:
http://www.sqlite.org/sqlitedll-3_6_6_2.zip
Mike
> -Ursprüngliche Nachricht-
> Von: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] Im Auftrag von Ti Ny
> Gesendet: Freitag, 28. November 2008 11:26
> An: sqlite-users@sqlite.org
> Betreff: Re: [sqlite]
I don't have DEF file :(
Ti Ny
> From: [EMAIL PROTECTED]
> To: sqlite-users@sqlite.org
> Date: Fri, 28 Nov 2008 11:17:54 +0100
> Subject: Re: [sqlite] sqlite3_open16 fails on Windows Vista 64b
>
> Have you given the DEF file to the linker? Are the exports visible in
> dependency walker? Is your
If you haven't specified the DEF file during linking, no symbol is exported.
There's no way for the .NET runtime to find the entry point without an
export table.
Mike
> -Ursprüngliche Nachricht-
> Von: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] Im Auftrag von Ti Ny
> Gesendet: Freita
>Have you given the DEF file to the linker? Are the exports visible in
>dependency walker? Is your DLL and the executable process type compatible
>(e.g. both 32 or 64-bits?)No I did not give DEF to linker (will try)
No, they are not
Executable and DLL are both 64b
Ti Ny
> From: [EMAIL PROTECTED]
Have you given the DEF file to the linker? Are the exports visible in
dependency walker? Is your DLL and the executable process type compatible
(e.g. both 32 or 64-bits?)
Mike
> -Ursprüngliche Nachricht-
> Von: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] Im Auftrag von Ti Ny
> Gesendet
>Are you sure that your sqlite.dll exports its API?
I downloaded sources available on the sqlite.org, is there anything special
that is required to do to export API?
> Like I said in my previous mail, I'd suggest using one of the already
> available and well-tested .NET wrappers.
Unfortunately t
Have you set ExactSpelling? EntryPointNotFound doesn't have to do with
CallingConvention. Are you sure that your sqlite.dll exports its API?
Like I said in my previous mail, I'd suggest using one of the already
available and well-tested .NET wrappers.
Mike
> -Ursprüngliche Nachricht-
>
It doesn't work even if I set CallingConvention. It fails on EntryPointNotFound
exception.
Ti Ny
> From: [EMAIL PROTECTED]
> To: sqlite-users@sqlite.org
> Date: Thu, 27 Nov 2008 19:57:30 +0100
> Subject: Re: [sqlite] sqlite3_open16 fails on Windows Vista 64b
>
> The given code is correct. The
Am 28.11.2008 um 09:20 schrieb Simon Bulman:
> Hi Jens,
>
> Thanks for your input. UTF-8 did not make a difference. I expected
> that
> SQLite file would be larger on disk than our proprietary format
> because of
> the overheads that you mention - I am surprised however it at least 7x
> large
Am 28.11.2008 um 09:20 schrieb Simon Bulman:
> Hi Jens,
>
> Thanks for your input. UTF-8 did not make a difference. I expected
> that
> SQLite file would be larger on disk than our proprietary format
> because of
> the overheads that you mention - I am surprised however it at least 7x
> large
Hi Jens,
Thanks for your input. UTF-8 did not make a difference. I expected that
SQLite file would be larger on disk than our proprietary format because of
the overheads that you mention - I am surprised however it at least 7x
larger.
I am actually recreating the whole database (delete file and r
27 matches
Mail list logo