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
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
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
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
4 matches
Mail list logo