24 replies to this topic

[Sphere]

I tried the ++ for each query, but it returns me a 0... for some unknown reason

The memory_get_usage I didn't know about though, gonna experiment with that tonight I think

[brewin]

Sphere, on Mar 24 2008, 06:27 AM, said:

I tried the ++ for each query, but it returns me a 0... for some unknown reason

Oh sorry, you need to specify global scope so it doesn't use the local version.

$num_queries = 0;

function Query() 
{
// query runs here
global $num_queries;
$num_queries++;
}

[Sphere]

brewin, on Mar 24 2008, 06:52 PM, said:

Oh sorry, you need to specify global scope so it doesn't use the local version.

$num_queries = 0;

function Query() 
{
// query runs here
global $num_queries;
$num_queries++;
}

I should've known that myself even...

[banj0]

The author of the Evolution CMS says that everything you need is in these 2 files.

 mysql.php   13.41K   3 downloads

 mysqli.php   12.72K   3 downloads

Hope that helps.

[Sphere]

Ok, got the query count working, except sadly for the AJAX queries, because those build the page, then insert the query results....

Ah well, it works

The memory_get_usage() function doesn't work on my server, and replacement (exec-function) is not allowed (how surprisingly ), so I need a workaround for that still.


And yes, the folks at PHP-NUKE can write their code better then me.... but hey, I'm still in development of improvement!
I already cleaned up like 50% of the useless junk I wrote a year ago

[banj0]

Sweet! Nice work Sphere!



0.18 seconds page load is pretty impressive. Are you using file cache or SQL cache?

[Sphere]

SQL cache, 90% of the page is SQL

It doesn't count in the Youtube and external image load btw

Ow, don't mind the amount of SQL queries, that's a bug I haven't figured out yet.

[banj0]

Sphere, on Mar 25 2008, 03:21 AM, said:

SQL cache, 90% of the page is SQL

Interesting. I disable my server cache to ease load but I may have to rethink that. Thx.

Quote

Ow, don't mind the amount of SQL queries, that's a bug I haven't figured out yet.

I'm averaging 52 queries per page for a forum. It's usually 0.9 to 1.3 seconds per page load. How many tables are you carrying?

[Sphere]

banj0, on Mar 25 2008, 09:15 AM, said:

Interesting. I disable my server cache to ease load but I may have to rethink that. Thx.
I'm averaging 52 queries per page for a forum. It's usually 0.9 to 1.3 seconds per page load. How many tables are you carrying?

Should be 3 tables in total, iirc

Well, the SQL chaching does increase server loads, but speeds up the page load when the server can handle it. If the server can't handle big caches very well, you'd better not use it

But for proof that there's some sort of error with the query count, check the photoalbum, it's completely AJAX, no SQL query whatsoever, and it still says 32 queries...

[banj0]

Sphere, on Mar 25 2008, 05:23 AM, said:

But for proof that there's some sort of error with the query count, check the photoalbum, it's completely AJAX, no SQL query whatsoever, and it still says 32 queries...

That is pretty weird.

As for the cache thing, I think I'm gonna turn on file caching and then try SQL and compare the 2. Might as well load it up and see how she flies. Plus it's shared so what the heck do i care, lol.

Your site is looking good bro! Nice job!