[sqlite] Re: suggest an index to make this faster

2007-04-21 Thread Igor Tandetnik
Dr Gerard Hammond wrote: Could somebody suggest an index(es) I could add to my sqlite v3 (REAL SQL database) to make this SELECT faster? SELECT date_trans, t.description, c.CategoryAbsolutePath, GST, total, TransID, HasSplitTrans, t.categoryID, t.Currency, t.locked FROM Transn t LEFT OUTER

[sqlite] suggest an index to make this faster

2007-04-21 Thread Dr Gerard Hammond
Hi Could somebody suggest an index(es) I could add to my sqlite v3 (REAL SQL database) to make this SELECT faster? SELECT date_trans, t.description, c.CategoryAbsolutePath, GST, total, TransID, HasSplitTrans, t.categoryID, t.Currency, t.locked FROM Transn t LEFT OUTER JOIN Category c on

[sqlite] 2 Threads - lock after Commit:

2007-04-21 Thread Matthew Veenstra
Hello, I was wondering if someone can shed a bit of light on a problem I am having. I am using SQLite in a client setting on Mac and Windows. I have two threads. That I use SQLite in. The main thread uses this to get data and display it to screen. Then I have a worker or

[sqlite] Re: DB design questions

2007-04-21 Thread A. Pagaltzis
Hi Michael, * Michael Ruck <[EMAIL PROTECTED]> [2007-04-21 22:35]: > Thanks for your response. Do you have a recommendation for a > simpler data store, which supports only simple queries (like, > equals, not equals on attributes) and transactions? BerkeleyDB might be a candidate. It only stores

AW: [sqlite] Re: DB design questions

2007-04-21 Thread Michael Ruck
Thanks for your response. Do you have a recommendation for a simpler data store, which supports only simple queries (like, equals, not equals on attributes) and transactions? Thanks, Mike -Ursprüngliche Nachricht- Von: A. Pagaltzis [mailto:[EMAIL PROTECTED] Gesendet: Samstag, 21. April

Re: [sqlite] sqlite3 shell doesn't install correctly

2007-04-21 Thread Ulrich Schöbel
On Saturday 21 April 2007 17:52, [EMAIL PROTECTED] wrote: > Ulrich =?iso-8859-1?q?Sch=F6bel?= <[EMAIL PROTECTED]> wrote: > > On Saturday 21 April 2007 15:40, Joe Wilson wrote: > > > Apply this patch to fix this problem. > > > > Thanks for the patch, but there is still something wrong in the > >

[sqlite] Re: DB design questions

2007-04-21 Thread A. Pagaltzis
* Michael Ruck <[EMAIL PROTECTED]> [2007-04-20 16:15]: > Is there anyone who has experience with this kind of design, do > you have better ideas on modelling this kind of data? This is actually a very typical approach to storing arbitrarily structured data entities in an SQL database that

Re: [sqlite] sqlite3 shell doesn't install correctly

2007-04-21 Thread drh
Ulrich =?iso-8859-1?q?Sch=F6bel?= <[EMAIL PROTECTED]> wrote: > On Saturday 21 April 2007 15:40, Joe Wilson wrote: > > > > Apply this patch to fix this problem. > > > > Thanks for the patch, but there is still something wrong in the > linking stage. > I do not understand why you are having

Re: [sqlite] Re: sqlite3 shell doesn't install correctly

2007-04-21 Thread Ulrich Schöbel
On Saturday 21 April 2007 15:40, Joe Wilson wrote: > > I've used SQLite-3.3.4 for quite a while, mostly the Tcl binding. > > A few days ago I installed 3.3.15 and the Tcl binding worked fine. > > Tonight I downloaded 3.3.16 and compiled it without any errors > > or warnings and then installed it.

[sqlite] Re: sqlite3 shell doesn't install correctly

2007-04-21 Thread Joe Wilson
> I've used SQLite-3.3.4 for quite a while, mostly the Tcl binding. > A few days ago I installed 3.3.15 and the Tcl binding worked fine. > Tonight I downloaded 3.3.16 and compiled it without any errors > or warnings and then installed it. When I tried to execute sqlite3 > the following error

Re: Re: [sqlite] How is the windows binary built?

2007-04-21 Thread Joe Wilson
--- Miha Vrhovnik <[EMAIL PROTECTED]> wrote: > > strip sqlite3.exe > is not ok at least for DLL, because it strips everything even reallocation > info. > strip --strip-unneeded sqlite3.dll The GNU toolchain's strip command corrupts the reallocation information for MinGW DLLs, so I would not

Re: Re: [sqlite] How is the windows binary built?

2007-04-21 Thread Miha Vrhovnik
> strip sqlite3.exe is not ok at least for DLL, because it strips everything even reallocation info. strip --strip-unneeded sqlite3.dll Regards, Miha "Joe Wilson" <[EMAIL PROTECTED]> wrote on 21.4.2007 5:48:00: >--- [EMAIL PROTECTED] wrote: >> I'm using cygwin under windows XP. >> gcc version