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

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 proceed

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 cor

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

[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 Apac

[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