Page 1 of 1

Need some advice

Posted: Mon Feb 02, 2004 10:00 pm
by phoggy
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.

Posted: Mon Feb 02, 2004 10:06 pm
by markl999
What version of MySQL?
Recent version can dp transactions which can reduce the overhead of lots of individual queries.

Posted: Mon Feb 02, 2004 10:32 pm
by phoggy
Hi,
thanks for your reply.
I'm using version 4.0.15.
Recent version can dp transactions which can reduce the overhead of lots of individual queries.
Huh? What does it mean to "dp transcations"? THX

Posted: Mon Feb 02, 2004 10:34 pm
by markl999
It was a typo :p Was supposed to say 'do transactions' and you can read about them here