What's your opinion

[chrisleon]

I have a php script that makes calls to a mysql database. I receive a file from our AS-400, that is ~ delimited, and it the import works great. My question is this: If I get this file daily, should I write a load data infile php script that would run in the cron on my unix server everyday. Or, should I place the loading of the file in my script everytime it is called. I think that is overkill, but I thought I would post the question and see what you guys think.

Thanx

[eoghain]

If you recieve the file once a day, just have a cron job do the work, as long as you can wait for the data update until the job runs. If you have to have the most up to date information available you'll need to have something checking for the file constantly and loading it as soon as it updates. Either way you should have all this work done behind the scenes. You should not have your PHP script that shows data to the user do this work.