In article <[EMAIL PROTECTED]>, Luckys <[EMAIL PROTECTED]> writes:
> I believe you should restrict number of rows that needs to be returned, or > giving a choice to the user, although showing the total count. Even if you > display all 20K records, no one is going to see them all, you can even add > one more LIKE condition to match the user's criteria. I second that. Whenever you connect an interactive application to a DB backend and you don't know in advance some upper limit for the number of rows returned by a query, append a "LIMIT 1000" or something like that. ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
