[neocorteqz]

Originally Posted by TECK

Chuan, what portal you use?
Is extremly intense on the table scans... Holly molly...


The number of queries is ok, but the code is not very strong, IMO.
Compare it yourself with any forums page. As soon as you go over 20% MySQL, you got to ask yourself what bad code you added there to perform table scans that generate those results...

it looks like the vBindex portal, but he has no copywrite info at the bottom, so i dont know.

as for the vBindex portal, this is what i get on portal home,

Page generated in 6.73733711 seconds (5.21% PHP - 94.79% MySQL) with 17 queries
NO Uncached Templates | DEBUG Mode OFF | GZIP ON (level 1) | 0.31 : 0.13 : 0.09

The slow loadtime is only because of the weather block i have on the portal home.

if I remove it.

Page generated in 3.35731196 seconds (9.05% PHP - 90.95% MySQL) with 17 queries
NO Uncached Templates | DEBUG Mode OFF | GZIP ON (level 1) | 1.11 : 0.31 : 0.15

is what i get. I'm sure NTLDR's code is fine. but I'm no coder, so i wouldn't know.