You are here: Re: MySQL Speed « PHP Programming Language « IT news, forums, messages
Re: MySQL Speed

Posted by Rik on 04/29/06 00:44

Ridge Burner wrote:
> Right now we are experiencing issues with MySQL being able to keep up
> The first SQL statement is used for ad
> banners, and our hoster has mentioned that this is not the most
> efficient way to do what were doing.

See my other post. Ν thought it was just an hypothetical(?) situation. For
this specific problem you can simply test yourself: create the table on your
local server, and test with for($i=1;$i<$number;$i++) where $number is an
arbitrary high number.

Note: this is the time the script takes, not neccesarily how long MySQL
takes. If it's just a case about MySQL which is to busy, and PHP has no
problem keeping up, it's a simple choice to choose to do more processing in
PHP.

Then again, I'm no server admin. Maybe someone else with more experience can
shed more light on the subject of processing by MySQL and PHP on production
servers.

(?)pfff, english, I hope it's the correct word and spelling)

Grtz,
--
Rik Wasmus

 

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

Π‘Π°ΠΉΡ‚ ΠΈΠ·Π³ΠΎΡ‚ΠΎΠ²Π»Π΅Π½ Π² Π‘Ρ‚ΡƒΠ΄ΠΈΠΈ Π’Π°Π»Π΅Π½Ρ‚ΠΈΠ½Π° ΠŸΠ΅Ρ‚Ρ€ΡƒΡ‡Π΅ΠΊΠ°
ΠΈΠ·Π³ΠΎΡ‚ΠΎΠ²Π»Π΅Π½ΠΈΠ΅ ΠΈ ΠΏΠΎΠ΄Π΄Π΅Ρ€ΠΆΠΊΠ° Π²Π΅Π±-сайтов, Ρ€Π°Π·Ρ€Π°Π±ΠΎΡ‚ΠΊΠ° ΠΏΡ€ΠΎΠ³Ρ€Π°ΠΌΠΌΠ½ΠΎΠ³ΠΎ обСспСчСния, поисковая оптимизация