Minimising SQL Calls.

[microbluechip]

Hi all,

I have asked this question before that to no avail. I currently have a number of SQL calls on the initial home page within my PHP application. The end result being that this page takes between 6 and 12 seconds to display depending on Internet conditions and this seems very slow even on my DSL connection.

Is there a method in PHP or SQL where I can simplify these SQL calls and get all the data that I need in just one initial SQL query and then say stick it into an array which can then be processed in memory wherever I need to access information.

The exception to this rule being updates, insertions and deletions which obviously needs to update the database via a SQL call.

[Danicek]

1. Normal optimized communication with database should not make your pageloads longer. I suppose that you have sql server on same maschine or very near your php server.

2. You should not only try to make less calls to database, but also to optimize this calls and to optimize your database.

3. You can ofcourse hold many information in arrays and miminaze your database accesses. I suppose that you automaticaly store information if you know that you will need them soon.

If you want more info, give us more info (size of your database etc.).