Re: [sqlite] pragma to load shared libraries (PATCH)

2005-11-18 Thread Robin Breathe
Nathan Kurz wrote: > On Wed, Nov 16, 2005 at 10:22:42AM +0000, Robin Breathe wrote: >> I'm intrigued to know how you loaded the additional shared library with >> your sqlite3(1) shell... is it simply a case of linking another library >> to it post installation, and if

Re: [sqlite] optimizing out function calls

2005-11-16 Thread Robin Breathe
register the user functions that library contains? Regards, Robin -- Robin Breathe, Computer Services, Oxford Brookes University, Oxford, UK [EMAIL PROTECTED] Tel: +44 1865 483685 Fax: +44 1865 483073 signature.asc Description: OpenPGP digital signature

Re: [sqlite] Rewriting a query

2005-09-30 Thread Robin Breathe
ter NATURAL INNER JOIN TransactionList >> GROUP BY sCommunityID; >> >> -- Clear filter ready for next time: >> DELETE FROM filter; > > Thread safety is an issue here. Multiple threads may be doing this action. > Also, by the (admittedly contorted) query I am using

Re: [sqlite] Rewriting a query

2005-09-29 Thread Robin Breathe
r as elegant. This method easily extends to any number of filtered sCommunityIDs, while anything in a single query is going to start getting "icky". Probably too late, but I've also found that indexing, grouping and joining are far faster on INT columns. If you could store sComm