I am thinking about the best way, how to update my records in database (MySQL) from XML feed. I have database and this database contains the daily offers from several sales portals.
So now - about midnight I am deleting all records from my table and with using script I am downloading new offers from portal (by their XML feeds). This way have one disadvantage -- the time interval among deleting old and inserting new records is ca 5 minutes -- and through this 5 minutes is table empty.
And I would like to ask you, if you could help me with some better way, how updating records in my table using better way...
Thanks a lot for your time!