You are here: slow mysql "sending data" stage between mysql and php « PHP Programming Language « IT news, forums, messages
slow mysql "sending data" stage between mysql and php

Posted by vladimir.plotnikov on 11/29/06 17:22

Hello!
I have problem:

I have IPB forum installed. After search in IPB (search takes about 3-4
seconds for post table about 300 000 records) mysql shows "Sending
Data"
status and takes about 3-5 minutes.

I tested with PHP 5.2, PHP 4.4, PHP 4.2.3 - with same results.
I switched from MySQL 4.2.18 to 4.2.21 and 4.2.22 with same result.

I tested with apache module, fastCGI with NGINX web server+fastCGI -
same
results.

I tested mysql connections with socket and network connection.

May be I missed some variables from php.ini?
May be I missed some from mysql server configuraion?

Main question - how I can speedup code for accept "Sending data" stage
between PHP and MySQL more fast?

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация