You are viewing a plain text version of this content. The canonical link for it is here.
Posted to modperl@perl.apache.org by Rajesh Mathachan <ma...@qlcomm.com> on 2000/10/11 11:04:44 UTC
hi all
hi all,
we have a query which goes to 7kb and we use mysql and php , th eserver
is literally crashing when we do the process
what is the other alternative fpor me
The site is aQuiz site
regards
rajesh mathachan
--------------------------------------------------------------
QuantumLink Communications, Bombay, India
Re: hi all
Posted by "Differentiated Software Solutions Pvt. Ltd" <di...@vsnl.com>.
Hi,
We had a similar problem with postgres db.
We had a large query running to 3 kb and the query ran forever without ever
getting completed.
We solved this, by breaking the query into parts and executing each part
separately... i.e., by creating a hash of the output of one step and filter
it into the next step and so on...
Hope this helps.
Murali
----- Original Message -----
From: Rajesh Mathachan <ma...@qlcomm.com>
To: <mo...@apache.org>
Sent: Wednesday, October 11, 2000 2:34 PM
Subject: hi all
> hi all,
> we have a query which goes to 7kb and we use mysql and php , th eserver
> is literally crashing when we do the process
> what is the other alternative fpor me
> The site is aQuiz site
> regards
> rajesh mathachan
>
> --------------------------------------------------------------
> QuantumLink Communications, Bombay, India
>
>
Re: [OT] hi all
Posted by Rodney Broom <rb...@home.com>.
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
Re: [OT] hi all
Posted by Dave Baker <da...@dsb3.com>.
On Wed, Oct 11, 2000 at 08:24:13PM -0700, Rodney Broom wrote:
> RM> we have a query which goes to 7kb...
>
> "7 kb"? I don't mean to be picky, but do you mean "seven kilo-bytes"? I'm
> thinking that either you mean some much larger number, or that I'm missing
> something terribly.
>
I read this as meaning the QUERY string is 7k in size, not the result set.
A 7k query is pretty hefty, however you slice it .... the words 'stored
procedure' come to mind (but that's always another story)
dave
--
- Dave Baker : dave@dsb3.com : http://dsb3.com/ : AIM#duirwyrd -
GPG: 1024D/D7BCA55D / 09CD D148 57DE 711E 6708 B772 0DD4 51D5 D7BC A55D
Re: [OT] hi all
Posted by Rodney Broom <rb...@home.com>.
RM> we have a query which goes to 7kb...
"7 kb"? I don't mean to be picky, but do you mean "seven kilo-bytes"? I'm
thinking that either you mean some much larger number, or that I'm missing
something terribly.
Either way, what does your query look like? Are you joining across 3 tables and
then back onto one of those tables again, and then using a bunch of LIKEs and
ORs? Or is this just a simple "select * from xyz"?
If it isn't obvious from your query as to what's the problems, then we should
probably know a bit about your server config. Like, "We're running on Win3.11".
;-)
----
Rodney Broom