Haseeb Iqbal wrote:
here is what i am trying to do.i have a PHP CLI script
> that will open a dbx file extract records from the dbf file
> one by one check is the record is already on the linux server
> (mysql database). if the record is already on the linux server
> then it will update the mysql
i have index the db properly. what next??
Haseeb
- Original Message -
From: "Rolf Brusletto" <[EMAIL PROTECTED]>
To: "Haseeb Iqbal" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, January 08, 2004 4:04 AM
Su
Haseeb - I would look at the indexes that it requires for the select
statments, if the db isn't indexed properly, it could be just
filesorting on each select(when you query to see if the record is in the
database on the mysql server). You can find out by putting explain in
front of your select
3 matches
Mail list logo
