I Need A Techincal Help Please

[isa]

Hi guys,
my problem is this. I'm mananging more than 20000 pages and I'm using mnay PHP scripts to show banners and some stuuf on my pages. I started using some flat text file then I switched to MySQL but I still have problems with my server. It slows down often and my provider seems no to be able to help me. I have a dedicated server really powerful but I think it could be misconfigured. I decide to modify my scripts including a .inc files with data to reduce load on my machine. Do you think it's correct ? Which is difference in reading a flat file or accessing to MySQL table or including a file ?

Any suggestio to reduce load on my server ?
How many calls can be tolerated by MySQL before slowing down ?

Thanks and Kisses
Isa

[keyDet79]

You may just have a very slow server, log into telnet or ssh and type 'top' to see all processes and their load. It is also possible you don't have enough RAM and it's starting to swap.

By the way you should never use a flat file unless your database is very small. I use it even when it's just a few records. When you use a file the whole thing gets read into the memory.

[isa]

Originally posted by keyDet79
You may just have a very slow server, log into telnet or ssh and type 'top' to see all processes and their load. It is also possible you don't have enough RAM and it's starting to swap.

By the way you should never use a flat file unless your database is very small. I use it even when it's just a few records. When you use a file the whole thing gets read into the memory.

Thanks keyDet79 but I'm using P4 2Ghz 2GB RAM so I don't think it's a slow server.

You're right and I'm using MySQL but I have the same problems

Isa

[genomega]

URL ?