You really should learn to use left joins. Im using them right now to start to clean up the amt of queries in the arcade addon first since it was using 92. So far I have cut 92 down to 52. thats 4 queries per game you have listed that have now been cut out. :) I now have gotten the arcade addon page down to 16 queries no matter how many games you list be it 1 or a 100. Trust me I tested it. Im going to go through and see about doing the rest of this hack and see what I can get it down to.

If the author doesnt mind. I will post my current modified file for everyone.


This is when listing 10 games on the page.

When using inner joins it generates the page in the following time.
Page generated in 0.18413091 seconds (41.08% PHP - 58.92% MySQL) with 16 queries

Now using left joins it generates the page in the following time.
Page generated in 0.28608704 seconds (26.56% PHP - 73.44% MySQL) with 16 queries

Only problem with the inner join is that you can only use the conditionals when running mysql 3.23.17

I can release both versions thats no problem.


High Stress Load Test
Original Code set to display 1000 games:
Page generated in 2.45838499 seconds (26.88% PHP - 73.12% MySQL) with 3164 queries

Optimized Code Using inner join's displaying 1000 games:
Page generated in 0.50021791 seconds (78.25% PHP - 21.75% MySQL) with 16 queries

Optimized Code Using left join's displaying 1000 games:
Page generated in 0.67386508 seconds (68.22% PHP - 31.78% MySQL) with 16 queries

Jepp.
Can you post or quote the optimized code, please?
Or better..., you release both versions with the code you used.

I am still learning php ;)

PcFreak

Heres the fixed version of the statistics file. Use the inner join version first and if it does not work for you then please use the left join. There shouldn't be any problems with table prefix's in the code but if there are let me know so that I can fix them. You can see my demo here of this file working. I will see about what I can do to the other pages latter on. http://www.extremechatforums.com/forums/statistik.php

:up:

Using these I am finding the game's mini-image doesn't show up, it isn't pulling the right info as the image properties don't show a gif name. (As opposed to it being a filepath error).

Oh yes I fogot I made a template change also. Let me get the template for you as well. When I changed the query's it changed the variable for the miniimage.

Replace statistic_arcade_bit with the following html

95% of my new vBulletin Boardstatistic Version 3 is finished.

Here some futures:

The new Boardstatistc Version 3

Detect vistor countries: 257
Detect Browserlanguages: 119
Detect Referer and Shortreferer (Domains)
Detect 17 different searchengines and log the keywords
Detect 291 Spider, Crawler and Searchrobots (work with the database of robots)
Detect Browser Plug Ins, resolutions, color depth, java and much more.
Show you all about the board (Topposters, most popular thread, threads without answers and many, many more)
Show all about the database (for example: show the attachment traffic and more)
More than 20 PopUps witch show more information
Found more about countries with Wikipedia (I have include a search function to the Wikimedia database)
Detect more then 50 different browser, more then 40 different os?s, WebService, and more then 20 WAP Browser
Make a systemcheck with the new Statistic (Show you all, what we can detect about your system)

a Live Demo your found here:

http://at-lantis.de/statistic.php

Now my little problem:
English is not my mother language. It?s very hard for me to translate this statistic in English.
The statistic is work with phrases. (will be imported in xml format).
All phrases are finished (not the phrases for the admincp).
Is there anybody whose want help me to translate them from german into other languages?

Would be really nicely


PcFreak

Now you're gettng me excited! Will all the icons you have in your demo be part of it?

Great job!

Surely.
All icons are freeware.
I found the most of them here: http://www.iconarchive.com/

PcFreak