Re: [PHP] Searching a Paradox Table with my PHP Script..

2002-07-12 Thread Kondwani Spike Mkandawire
I have a lot of things to change including the whole strategy... Thanks for the responses... It ended up being a whole number of factors that were slowing the Script down... Thanks again... Miles Thompson [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Why are

[PHP] Searching a Paradox Table with my PHP Script...

2002-07-11 Thread Kondwani Spike Mkandawire
Hallo folks: I have a bit of an issue with Paradox Table Searching... I have a fairly large table (4MB+), here is the problem: When I run a search for an element in the Table on my localhost which is running Apache and php 4.1, I have no issues with speed... However when I run it on the Server

[PHP] Searching a Paradox Table with my PHP Script..

2002-07-11 Thread Kondwani Spike Mkandawire
Hallo folks: (Sorry for a repost on the same topic just that my first one never got through)... I have a bit of an issue with Paradox Table Searching... I have a fairly large table (4MB+), here is the problem: When I run a search for an element in the Table on my localhost which is running

Re: [PHP] Searching a Paradox Table with my PHP Script...

2002-07-11 Thread Chris Hewitt
Kondwani Spike Mkandawire wrote: Hallo folks: I have a bit of an issue with Paradox Table Searching... I have a fairly large table (4MB+), here is the problem: I've not been monitoring this thread so what I say may have been covered, so please bear with me. When I run a search for an

Re: [PHP] Searching a Paradox Table with my PHP Script...

2002-07-11 Thread Kondwani Spike Mkandawire
Is the table layout, indices, amount of data and ODBC connection the same in both cases? How long is ages? If minutes then is it a DNS problem in connecting to the server computer? You could try this by getting an item of data from a new table containing only one row. Do I understand

Re: [PHP] Searching a Paradox Table with my PHP Script..

2002-07-11 Thread Miles Thompson
Why are you building the array? Why not let SQL do the work? Select col1, col2, col3, ... coln from target_table where field_holding_target_value = '$target_value_i_want' If you have no records returned, then no match, otherwise you have one or more matches. In the second case you can