Need some advice
Moderator: General Moderators
Need some advice
I'm using Dreamweaver, PHP, MySQL and IIS on WinXP to update a 20 MB database. I have created a form and added a button to set the action to the script i'm using to process the data. It's a rather short script to update one field. I have set the timout limit in PHP to 0 and chosen a very high number for IIS(I'm not sure it can be set to no limit). What happens is that for the first couple of minutes, it processes rather fast, then it slows down to a crawl and finally, about a quarter of the way of processing, the computer freezes. So I want to know what am i doing wrong here, i mean mysql can handle terabytes of data, so it should not be choking at 20MB. Is there something wrong with the way I have set everything up? Is DW not a good choice for processing large databases? Is IIS the problem? Can't be the script, it's not very long. I don't know which one is the weak link here. Keep in mind, I'm rather new to this, so I may go about this all wrong. Could someone give me some input on this. Very much appreciated. TIA.
It was a typo :p Was supposed to say 'do transactions' and you can read about them here