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 <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
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
>
>
