Re: Query Speed in Terminal vs. PHP

2004-03-02 Thread Saqib Ali
Is index defined on all of your tables? Saqib Ali - http://validate.sf.net < (X)HTML / DocBook Validator and Transformer On Tue, 2 Mar 2004, Chris Fowler wrote: > I have a query that is admittedly inefficient in that it is doing > multiple OR clauses and joining multiple tables.

Re: Query Speed in Terminal vs. PHP

2004-03-02 Thread Daniel Kasak
Chris Fowler wrote: I have a query that is admittedly inefficient in that it is doing multiple OR clauses and joining multiple tables. However, the query runs at an acceptable speed if I am in a terminal session and run the query directly in the terminal. On the other hand, when PHP performs th

Query Speed in Terminal vs. PHP

2004-03-02 Thread Chris Fowler
I have a query that is admittedly inefficient in that it is doing multiple OR clauses and joining multiple tables. However, the query runs at an acceptable speed if I am in a terminal session and run the query directly in the terminal. On the other hand, when PHP performs the same query for use