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
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
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
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
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
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
> >
* 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
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
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.
> 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
--- 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
> 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
12 matches
Mail list logo