Re: [SQL] Simple SQL Question

2004-11-09 Thread Andras Kutrovics
ith 3 or more keys and 500.000 records , where the performance of this method is poor. Maybe I will end up using limit and offset in case of incremental fetching,but if the table is modified between requests, it can behave weird. Is there a perfect solution to this? Sorry for the e

[SQL] Simple SQL Question

2004-11-05 Thread Andras Kutrovics
n sql. (It it is possible). Thank you in advance Andras Kutrovics ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]