Insert & update very very slow in MySQL

rvpals

I made a table called article, in which has fields title and content, content is a text field.

The purpose is to copy and paste some interesting news piece from the internet and store it in the database.

It was OK when I have a fairly small article to paste in content (the insert takes 3 seconds), however, if I try to paste a longer article. Then wait for the insert statement to finish, it takes forever (like 4 minutes). The same thing happened with update.

I suspect the problem is the size of input sending to mysql server. Is there a setting I can tweak to make it takes input bigger buffer size or something? I don't know if that is a problem with PHP or mysql?

After I hit insert button to post the content, the browser said sending request to server, then wait for a long long time, then finally browser says "waiting for server", then the operation is done.

Thanks a lot.

SumitGupta

Hi,

It seems that it is not the problem with the content of your Text but it is the problem in with slow communication between your browser and Web server.

I have done almost the same thing and it took few second to insert a content of 100K from a post data.

also How do you take the Input of Article content?
Is there any Textarea given of You do web spidering to get your content?

It seems you have some Background parsing going on your content as well that might slow down a bit as well.

rvpals

SumitGupta wrote:
Hi,

It seems that it is not the problem with the content of your Text but it is the problem in with slow communication between your browser and Web server.

I have done almost the same thing and it took few second to insert a content of 100K from a post data.

also How do you take the Input of Article content?
Is there any Textarea given of You do web spidering to get your content?

It seems you have some Background parsing going on your content as well that might slow down a bit as well.

All I did:
$content = trim($_POST['content']);
insert into article content VALUES ('$content');
...