Need some advice

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
phoggy
Forum Newbie
Posts: 20
Joined: Tue Sep 16, 2003 2:03 pm

Need some advice

Post 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.
User avatar
markl999
DevNet Resident
Posts: 1972
Joined: Thu Oct 16, 2003 5:49 pm
Location: Manchester (UK)

Post by markl999 »

What version of MySQL?
Recent version can dp transactions which can reduce the overhead of lots of individual queries.
phoggy
Forum Newbie
Posts: 20
Joined: Tue Sep 16, 2003 2:03 pm

Post 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
User avatar
markl999
DevNet Resident
Posts: 1972
Joined: Thu Oct 16, 2003 5:49 pm
Location: Manchester (UK)

Post by markl999 »

It was a typo :p Was supposed to say 'do transactions' and you can read about them here
Post Reply