"recent topics" in SMF style

[bloc]

Well, that might explain it..and quite the trouble maker too, it limits what you can use of scripts and how many users can visit at any given time.

[Techdomain]

ouch... means just another thing (trap) to look out for when you are choosing a host!

[hartiberlin]

Well,
the limit of 70.000 queries now has almost
made my website unaccessible !

I have to click 10 time so I donÂÃ,´t get the
error message !

Please help.

How can I setup TP and SMF1.1RC3,
so it does consume the lowest amount of
Database querries ?
On my hoster I have MySQL 3.x
databases.

But they strictly limit the database queries to
70.000 queries per hour
and now as I had the 100 recent topics on
my TP frontpage and inside the InfoCenter Box
on the forum main page at the bottom,
it seems these 70.000 queries are used
up quite rapidly..

Should I change the most recent topics back to just
10 to have less queries ?

Many thanks.

Best regards, Stefan.

[technodragon73]

Yes you should...each topic listed is at least one query...multiply that by the number of users online each (you mentioned 39 users at any given time) minute is about 4000 queries a minute when you add in the queries for each block as well.

[bloc]

The best way to get under that 70.000 limit is of course turning off every mod - including TP - so that SMF runs on just minimal number of queries.

[jacortina]

The best way to get under that 70.000 limit is of course turning off every mod - including TP - so that SMF runs on just minimal number of queries.

True. But I don't think TechnoDragon's characterization is correct. It shouldn't require a query per topic any more than listing messages in a thread would require a query per message to display a thread (you can see this is not the case when you display a topic with only one or two replies and one which has a couple of pages but can be displayed by showing 'All'; the total queries required aren't that different and are more dependent on number of different posters included in the thread).

Similarly, when I display Members (http://www.tinyportal.net/smf/index.php?action=mlist), it shows 30 members on the page without taking over 30 queries (stats show page required 22 queries).

(Of course, it IS possible to hack SMF to connect to the DB using different ID's, each with its own limit of 70k queries/hr.)

[hartiberlin]

Where do I see the amount of queries TP with SMF does to the database ?

In my footer it does only display:
Powered by SMF 1.1 RC3 | SMF ÂÃ,© 2001-2006, Lewis Media
TinyPortal v0.9.6beta ÂÃ,© Bloc | Azure design by Bloc

[hartiberlin]

How much queries per hour does Tinyportal.net generate about ?

Can I limit the queries to the database, when I have more postings
in each thread ?

So instead showing 10 postings per thread , show 20 postings in each thread
per page ?

Will this reduce the queries load onto the database ?
As the users would just read longer in each page and
donÂÃ,´t need to load so often the next page ?

[hartiberlin]

Is a limit of 70.000 queries per hour low ?
What does your hostings providers offer ?

The problem is getting worse now in this moment..
I canÂÃ,´t access almost anymore my own forum...

I only get this limit error...

I had in about 20 hours now 13000 hits to my
startpage.
Is this normal,
when about 30 to 50 users are online all the time in my
overunity.com forum ?
Or could this be a DDOS attack ?

[hartiberlin]

MurphyÂÃ,´s law hits always, as breaking news breaks...
Now somebody can light a 60 Watts bulb with a 9 Volts battery
and now forum does not work reliable...

See:
http://www.overunity.com/index.php/topic,712.2260.html


So how could I easily reduce the queries more,
without deinstalling TinyPortal and the Admod ?
These are the only MODs I use.
Many thanks...