So... does anyone have some tips to get IPB to run faster on my server? I use the presistant connections for mysql currently. But, does anyone else have a suggestion/tip for me?

Thank you very much,
Jared

Cut down on some uneeded queries: for example, you see the thing on the bottom of every topic that tells you who's reading the topic at the moment? That is one of the things that does produce more queries, so there's one thing you could turn off.

If it's possible (and I'm sure it is), you could try making Lo-Fi version the default viewing.

No one wants to do that though. :S

And as MrsSim suggested, the lower queries and it should be faster.

What speed are you getting? Because if you're getting a rate of, say, 0.1 to 0.2 seconds, then that's not too bad. If it's taking 2.0 to 3.0 seconds (or longer), then you have problems. Also if you're using v2.0.x then you can probably do without the persistant connections. (I recently discovered that I have it set off, when I turned it on, no noticable improvement, so I turned it back off).

You should also consider doing the following:
1. Back up your database (always do this on a regular basis anyway)
2. Check for errors on the database.
3. Repair the tables (if there are any errors)
4. Optimize all the tables (can take awhile if you have a lot of data!)
5. Enjoy the results.

Also check your task log, do you really need everything in there? If not, delete that out (before optimizing the database). Do you really need to have members birthdays show? If not, turn that off because that'll knock the queries down by 1. There are other options you can turn off. I think the MINIMUM number of queries you can hope to achive is 5 (I could be wrong though). To me, if cutting it down to 5 (if you're at 8) only saves you a fraction of a second, then it's not worth the savings. But thats just me.

Now if you're talking about the loading of pages on the client end (the web browser), that's dependant on the views bandwidth, computer, etc.

Start by turning off persistent connections Seriously, they are a very bad idea. I'm surprised you can get them to work at all. How big is your site and why do you want to speed it up? Is it too slow? Bored? Geek?

ok, some basic tips:

1. Run your database from a different server than your web server. Most small sites run them both on one system.
2. Convert your session table to HEAP: mysql -u root -p -e "alter table ibf_sessions engine=heap;"
3. Convert all of your other tables to INNODB. This will dramatically improve response. Reads are about the same speed but writes are vastly improved.
4. The biggest database bottleneck is your disk(s) and RAM. Start by running a RAID 0+1 array (4 disks) and increase that to as many disks as you can stuff in. The more spindles in the array the faster it will be. several smaller striped disks are faster then one large one.
5. Look at the load of your servers. If you have a high load average but your CPU usage is less than 100% then it's your disks that are slowing you down. A fully loaded server has a load average of 1.00 * number of CPUs. Thats 1.00 for a single CPU server, 2.00 for a dual CPU server. A load average of more than full load will work fine but is overloaded. Load average on my servers can peak as high as 100 at times.

There is a whole art and science to scaling your system beyond these basic tips.

Good luck

You are assuming that it's on his own personal server and not through a hosting company.

Ironic. Persistent connections are most useful when your database is on a different server.