Re: speed

From: Armando Padilla (mando81_at_prodigy.net)
Date: 02/20/05 

Date: Sun, 20 Feb 2005 14:36:25 GMT

windandwaves wrote:
> Hi Folks
>
> I am putting together a couple of tables in PHP/MySql that are rather large:
>
> 137 fields with at least about seventy medium text field.
>
> The table only contains about 500 rows and will never grow substantially (well, it would be nice (they are members).
>
> 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
> newby, I did not like that idea.
>
> Should I be worried about speed? and if so, how I can I measure speed.
>
> I know it all depends.
>
> I use a standard ISP package (not a dedicated server). I expect only a handful users of the website at the same time. These large
> tables are read by a page that displays all the information (address, characteristics, prices, etc...) from all 136 fields. No
> difficult queries are used at all.
>
> I would love to hear any experiences that you may have had that can help me.
>
> - Nicolaas
>
>
Hey there,

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
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. This will allow you to scale your
application up down the road. Also try to add Indexes to your table
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
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,

/***
* START OF PAGE
*****/
$starttime = time();

/****
* END OF PAGE
******/
$endtime = time();

echo "Page took: ".$endtime-$starttime." to load.";

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

Relevant Pages

  • test db connection
    ... I created an asp.net app to pull a large amount of data, from a mysql DB. ...
    (microsoft.public.dotnet.framework.aspnet)
  • 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: DBD::ODBC as "middleware" between Crystal Reports and MySQL
    ... Most users connect to our MySQL databases via web applications. ... However, in addition to the web apps, some power users use Crystal ... middleware app which lives in the DMZ and shuttles data between ...
    (comp.lang.perl.misc)
  • Re: Subscript out of range, obvious?
    ... All your client apps could declare that logging object WithEvents so ... My master app is trying to ... master program is running. ... I prefer MySQL, and there are others for free. ...
    (microsoft.public.vb.general.discussion)
  • Re: Subscript out of range, obvious?
    ... All your client apps could declare that logging object WithEvents so ... My master app is trying to ... master program is running. ... I prefer MySQL, and there are others for free. ...
    (microsoft.public.vb.general.discussion)