Re: hitting the limits

Rik wrote:
windandwaves wrote:
It is so hard for me to judge if the code is efficient. Really - who
knows. I know what efficient code is, but there are just so many
variables. Even making changes tot the php.ini could be huge.

Yup, but previous suggestion with microtime() would give you an
indication where the most time is taken.

Yes, I may try that, but i found that pages load superfast one second and
almost not at all the next. I did some database work last night with a
script running through an entire table of 20,000 records one by one. I did
an echo for each line and it was really interesting to see that sometimes
the entire screen filled with echos within a split second, while the next
moment, each line would literally take one second.


Each page loads about 100Kb of libaries and functions... (probably 50
- 100 functions (small ones) in total)... Does that make a
difference?

Yes, probably not a lot, but why?
I'm having great difficulties imagining a a website where that much
libraries and functions are needed. Maybe it's time to include only
files that are actually needed?

Yes, that is for sure, but sorting out exactly what is needed for each page
take expensive development time.


It may be worth it to check the following url:
http://nl2.php.net/manual/en/language.oop5.autoload.php

I have a couple of tables in the database with over 300,000 (small)
rows)... Does that make a difference?

Having a database doesn't make a differnce.
Exactly HOW you query the database does.

Lol, yes, I guess you are right. I have added lots of indexes so querying
should be pretty fast, but adding may take longer....

I have one unique index that compromises five fields, would that matter?

So many questions, so few clues

Normalize and create proper indexes.-

Grtz,


.

Relevant Pages

  • Re: hitting the limits
    ... windandwaves wrote: ... I know what efficient code is, but there are just so many ... Even making changes tot the php.ini could be huge. ... Having a database doesn't make a differnce. ...
    (comp.lang.php)
  • Re: [PHP] peer review (was php framework vs just php?)
    ... the database. ... Additional arguements may be supplied to indicate columns to ... echo "<input ... single quotes in the Type column of the ...
    (php.general)
  • Re: [PHP] peer review (was php framework vs just php?)
    ... function formCreate($database, $table, $action, $excludeCols, ... the database. ... Additional arguements may be supplied to indicate columns to ... echo "<input ...
    (php.general)
  • RE: [PHP] Re: php framework vs just php?
    ... function formCreate($database, $table, $action, $excludeCols, ... the database. ... Additional arguements may be supplied to indicate columns to ... echo "<input ...
    (php.general)
  • peer review (was php framework vs just php?)
    ... function formCreate($database, $table, $action, $excludeCols, ... the database. ... Additional arguements may be supplied to indicate columns to ... echo "<input ...
    (php.general)