DB> I read this as meaning the QUERY string is 7k in size, not the result set.
Hmm, I didn't think of that. Yes, that would be a big query.
DB> ...the words 'stored
DB> procedure' come to mind (but that's always another story)
Yes, no stored proceedures in mysql. But if this does refer to 7KB of text in
the query, then I have to think that there's a better way to write it. I wrote a
little search engine that did a bit of:
where (
id = 3 or
id = 5 or
id = 2838
...
)
But that was to get around a bad LIKE statement. And it actually runs pretty
well. My thought would still be that the statement can probably be cleaned up a
bit. Hey Rajesh, I know that you probably don't want to share the exactities of
the query for business reasons, but any indication you can give would help in my
oppinion.
----
Rodney Broom