Re: speed

From: windandwaves (winandwaves_at_coldmail.com)
Date: 02/21/05 

Date: Mon, 21 Feb 2005 12:05:36 +1300

"Armando Padilla" <mando81@prodigy.net> wrote in message news:Jf1Sd.6762$BK4.316@newssvr31.news.prodigy.com...
[....]
> here is my 2 cents on this issue. I think a PHP programer must at least be somewhat well versed in database design. (personal
> opining) Being

I am, it is the PHP that I lack

> that much of what we do is manipulate adn manage data that a web user sends and receievs from our websites. From a scalable sense
> you really need to Normalize your tables.

It is very unlikely that they will grow datawise to more than about 5,000. It is in fact physically impossible.

> This will allow you to scale your application up down the road. Also try to add Indexes to your table

I have

> structure, use the EXPLAIN function for mysql to check out how well your connections are doing, and if you will have a large
> amount of people

how does this work?

> coming to your site go ahead and open persistant connections to mysql (mysql_pconnect)
>
> If you want to test how fast your app is going to run (or running) try benchmarking it,

I thought about that, brilliant.

>
> I dont know if there are any apps out there that will determine how fast a page will load when X amount of users hit the site but
> you might want to google that.
>
> Well hope this helps.
> Armando Padilla

Thank you Armando

Relevant Pages

  • Re: speed
    ... >> I could have created a dozen or so tables, which would have been a lot sexier from a database design perspective, but as I am a PHP ... > If you want to test how fast your app is going to run try ... > a page will load when X amount of users hit the site but you might want ... > Armando Padilla ...
    (alt.php)
  • Re: Storing & Manipulating Currency in the database.
    ... use), and abbreviations (e.g. 'USD' = US Dollars), also for the UI. ... Lira was not a supported currency;) ... we are currently in the exploratory phase of building a> financial app that has the requirement of globalization support. ... Further, if the input currency is in Turkish Lira> then I would end up with a small fraction representing USD, 1 Turkish> Lira = 0.0000006942 USD, unless I have large amounts of Lira my USD> amount will always be a fractional amount. ...
    (microsoft.public.sqlserver.programming)
  • Re: speed
    ... use the EXPLAIN function for mysql to check out how well your ... coming to your site go ahead and open persistant connections to mysql ... If you want to test how fast your app is going to run try ... a page will load when X amount of users hit the site but you might want ...
    (alt.php)
  • Storing & Manipulating Currency in the database.
    ... financial app that has the requirement of globalization support. ... there are about 1.4 million Turkish Lira per U.S. Dollar. ... then I would end up with a small fraction representing USD, ... amount will always be a fractional amount. ...
    (microsoft.public.sqlserver.server)
  • Storing & Manipulating Currency in the database.
    ... financial app that has the requirement of globalization support. ... there are about 1.4 million Turkish Lira per U.S. Dollar. ... then I would end up with a small fraction representing USD, ... amount will always be a fractional amount. ...
    (microsoft.public.sqlserver.programming)