By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,654 Members | 1,842 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,654 IT Pros & Developers. It's quick & easy.

speed

P: n/a
Hi Gurus

I am building my first ever PHP site. Should I worry about speed?

These are the parameters of my site

- MySQL database with about 500 records (about 50 fields each) and a couple
of small related tables
- about two or three visitors at the same time
- hosted on fast and large server in the US

Let me know what else I should consider and how/if I should tweak for speed.

TIA

- Nicolaas
Jul 17 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
WindAndWaves wrote:
Hi Gurus

I am building my first ever PHP site. Should I worry about speed?

These are the parameters of my site

- MySQL database with about 500 records (about 50 fields each) and a couple
of small related tables
- about two or three visitors at the same time
- hosted on fast and large server in the US


For something like that speed won't be that big of a concern, anything
you do will probably be fast enough. Obviosuly it never hurts to
consider speed and always try and make things as fast as you can, but if
you find yourself trying to do something that will be fast and cannot
manage to get it working, don't hesitate to consider doing it a slower,
yet easier way. It would probably take some extreamly bad code to make
the site slow enough to notice any problems with a setup like that.
Jul 17 '05 #2

P: n/a

"kicken" <sl***@aoeex.com> wrote in message
news:ie********************@bresnan.com...
WindAndWaves wrote:
Hi Gurus

I am building my first ever PHP site. Should I worry about speed?

These are the parameters of my site

- MySQL database with about 500 records (about 50 fields each) and a couple of small related tables
- about two or three visitors at the same time
- hosted on fast and large server in the US


For something like that speed won't be that big of a concern, anything
you do will probably be fast enough. Obviosuly it never hurts to
consider speed and always try and make things as fast as you can, but if
you find yourself trying to do something that will be fast and cannot
manage to get it working, don't hesitate to consider doing it a slower,
yet easier way. It would probably take some extreamly bad code to make
the site slow enough to notice any problems with a setup like that.


Ok, thank you.

The reason I asked was that the site I am working with searches text fields
rather than ID numbers, but I guess it is nothing really to worry about.
Jul 17 '05 #3

P: n/a
WindAndWaves wrote:
Hi Gurus

I am building my first ever PHP site. Should I worry about speed?

These are the parameters of my site

- MySQL database with about 500 records (about 50 fields each) and a
couple of small related tables
- about two or three visitors at the same time
- hosted on fast and large server in the US

Let me know what else I should consider and how/if I should tweak for
speed.
Hi Nicolaas,

You probably don't have to worry.
PHP is very fast and your database very small.

But of course, it all depends on what you do.
If you have 500 records with 50 fields, and you are doing some very
complicated itterated math stuff over all the fields, things will be slow.

However, if you just search some fields, and make some joins, that will be
done very quickly.

So it all depends...

Very stupid but true advise: Just test it. :-)

I also agree with Kicken's response: Try to make your code fast, but if you
get stuck: simplify (and slower) your code.
Clear, good understandable code is more important than speed in my humble
opinion, especially when you are new to PHP/databases.
Just make sure that you know what you are doing, maybe after that start
worrying about speed.

Regards,
Erwin Moller

TIA

- Nicolaas

Jul 17 '05 #4

P: n/a

"Erwin Moller"
<si******************************************@spam yourself.com> wrote in
message news:41**********************@news.xs4all.nl...
WindAndWaves wrote:
Hi Gurus

I am building my first ever PHP site. Should I worry about speed?

These are the parameters of my site

- MySQL database with about 500 records (about 50 fields each) and a
couple of small related tables
- about two or three visitors at the same time
- hosted on fast and large server in the US

Let me know what else I should consider and how/if I should tweak for
speed.
Hi Nicolaas,

You probably don't have to worry.
PHP is very fast and your database very small.

But of course, it all depends on what you do.
If you have 500 records with 50 fields, and you are doing some very
complicated itterated math stuff over all the fields, things will be slow.

However, if you just search some fields, and make some joins, that will be
done very quickly.

So it all depends...

Very stupid but true advise: Just test it. :-)

I also agree with Kicken's response: Try to make your code fast, but if

you get stuck: simplify (and slower) your code.
Clear, good understandable code is more important than speed in my humble
opinion, especially when you are new to PHP/databases.
Just make sure that you know what you are doing, maybe after that start
worrying about speed.

Regards,
Erwin Moller


Yep, I think you are right... I am just a bit anorexic when it comes to code
and the like - so I started to worry about it, now I am just trying to write
simple codes - the less lines the better....keeping it simple.

Thank you for your info

- Nicolaas
Jul 17 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.