Reduce the amount of Quieries on a web page

[dfr574]

hello,

I have a Intranet site that I created for work that tracks production (where a item is in the cycle) in html form.

FreeBSD 4.9 stable
Apache 1.3.27
php 4.4-3.1
MySQL 3.23

The problem is that the page has 95 quite complex quieries (reference 6-11 tables) with over 100 users connected @ one time refreshing every 2 seconds. 9500+ quieries every 2 seconds slows the system down to a snails pace.

What I would like to do is create something (I have no idea what or how). That will quiery the database 95+ every 2 seconds then have the users (web browser) grab the info from that, without any quieries or a limited amount of queries.

I hope this make's sense.....
To make it short I need to reduce the amount of quieries but keep all users up to date.

Any suggestions will be helpful
Thanks

[Sxooter]

What you probably want to do is select the data into a temporary table every X seconds, and then have the scripts pull the data from there.

Materialized views would be good for this kind of thing.

But more importantly, it sounds like you may be doing a lot of hand joining of data. If you can rewrite your queries to join the data for you it should speed things up, as long as the joins are fairly simple. MySQL can have performance issues on joining a large number of tables.

[dfr574]

Sxooter thank you for the reply.

This was the first db that I designed so I normalized it as much as I could (bad decision).

I was also thinking a temp table or a seperate db.

Tuesday I'll post a few of the queries , so you could point me in the right direction....if you don't mind.

Maybe they are writen wrong

Thanks again!