Good feedback. I haven't done a memory check on that machine in a
while
Next on my list.
On Sun, Dec 4, 2016 at 11:25 AM, Keith Medcalf wrote:
>
> If pressing the CAPS LOCK or NUM LOCK keys on the keyboard does not toggle
> the light on the keyboard then you have lost
On 7 Dec 2016, at 11:28pm, Jay Weinstein wrote:
> Is it correct to say busy timeout will work for two separate processes and
> I don't have use fork in C/C++ or ProcessBuilder in java to execute one as
> a child and a parent?
The timeout setting is attached to the database
Hi,
Is it correct to say busy timeout will work for two separate processes and
I don't have use fork in C/C++ or ProcessBuilder in java to execute one as
a child and a parent?
Thanks,
Jay
On Wed, Dec 7, 2016 at 11:02 AM, R Smith wrote:
> Yes, multiple access is a feature,
On 7 Dec 2016, at 8:40pm, David Raymond wrote:
> Question on making indexes for the child fields of foreign keys. I have a
> child table with a number of foreign keys on fields which the majority of the
> time are null. I've currently got indexes on the child fields
Thanks for the info!
On Wed, Dec 7, 2016 at 11:02 AM, R Smith wrote:
> Yes, multiple access is a feature, a basic necessity even.
>
> The answer is here:
> http://www.sqlite.org/pragma.html#pragma_busy_timeout
>
> Explanation:
>
http://www.sqlite.org/foreignkeys.html#fk_indexes
Question on making indexes for the child fields of foreign keys. I have a child
table with a number of foreign keys on fields which the majority of the time
are null. I've currently got indexes on the child fields for the purposes of
speeding
Yes, multiple access is a feature, a basic necessity even.
The answer is here:
http://www.sqlite.org/pragma.html#pragma_busy_timeout
Explanation:
https://www.sqlite.org/c3ref/busy_timeout.html
and
http://www.sqlite.org/tclsqlite.html
see the section: The "timeout" method
On 2016/12/07 8:54
On 7 Dec 2016, at 6:54pm, Jay Weinstein wrote:
> I’m running two programs, one written in java and one written in C, which are
> both trying to access a sqlite database. I'm getting the error
> org.sqlite.SQLiteException: [SQLITE_BUSY] The database file is locked
>
Hi,
I’m running two programs, one written in java and one written in C, which are
both trying to access a sqlite database. I'm getting the error
org.sqlite.SQLiteException: [SQLITE_BUSY] The database file is locked
(database is locked) when I run both as separate processes and when the java
On 12/7/16, Ralf Junker wrote:
>
> I assumed that
> binaries on sqlite.org would omit test code for best performance.
We go by the principle of "Fly what you test, and test what you fly".
>
>> The SQLITE_OMIT_BUILTIN_TEST option is untested and unsupported.
>
> This was not
On 07.12.2016 14:21, Richard Hipp wrote:
Side note: I notice that the SQLite binaries (Windows, at least) are not
compiled with SQLITE_OMIT_BUILTIN_TEST and not affected by the problem.
Is there a reason to omit SQLITE_OMIT_BUILTIN_TEST from the builds, as
it adds at least some overhead?
>
On 1 Dec 2016, at 7:24am, Stephan Stauber wrote:
> SQLite 3.8.5: to INSERT 380.000 records into a in
> inMemory Database it takes 10 seconds
> SQLite 3.10.0 to INSERT 380.000 records into a in
> inMemory Database it takes 35
On 12/7/16, Ralf Junker wrote:
>
> Side note: I notice that the SQLite binaries (Windows, at least) are not
> compiled with SQLITE_OMIT_BUILTIN_TEST and not affected by the problem.
> Is there a reason to omit SQLITE_OMIT_BUILTIN_TEST from the builds, as
> it adds at least some
Alarming side effect of SQLITE_OMIT_BUILTIN_TEST: It renders the fix
[005d5b87] for ticket [da784137] useless.
Ticket: http://www.sqlite.org/src/info/da7841375186386c
Fix, trunk: http://www.sqlite.org/src/info/005d5b870625d175
Fix, 3.15.2: http://www.sqlite.org/src/info/27438fb43db4eae9
sorry for the delayed response.
with 3.15.2 it is even worse ( it takes 1246s to INSERT 380.000 records)
with 3.8.5 it took only 10s
Best regards
Stephan
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
>1) SELECT * FROM TEST WHERE posted = 1;
>[(‘inv’, 100, 1)]
>
>2) SELECT * FROM TEST WHERE posted = ‘1’;
>[(‘inv’, 100, 1)]
>
>3) SELECT * FROM TEST WHERE CASE WHEN tran_type = ‘inv’ THEN posted END = 1;
>[(‘inv’, 100, 1)]
>
>4) SELECT * FROM TEST WHERE CASE WHEN tran_type = ‘inv’
Wednesday, December 7, 2016, 9:15:57 AM, you wrote:
Thanks Ryan, this looks very useful, think I've got what I need now to
make it work!
Richard
>> But how do I do this for multiple records and mutiple fields? I
>> imagine I need to use SQLiteTransaction here but I'm not sure about
>> the
Wednesday, December 7, 2016, 3:12:05 AM, you wrote:
>> On Dec 6, 2016, at 5:40 PM, Richard Andersen wrote:
>>
>> cmd.CommandText = @"UPDATE pdata SET FileName = @fileName WHERE FileName =
>> 'filename.zip'";
> You can add other columns to set by adding more “name = value”
>
On 2016/12/07 3:40 AM, Richard Andersen wrote:
I have a table with several thousand records each with multiple
fields. One field contains a filename, this is the only unique field
so I use it to identify the different records.
What I need is a way to update all fields that have changed in any
19 matches
Mail list logo