UBB.Developers Forums General Discussion Suggestions and Feedback What happens when I change my default view?

If I change my forum from default threaded to flat view - what will mu readers experience? Will anything change for them or will this affect only new users.

My database is overloaded, so I need to reduce queries. How can I force all users to switch once and then allow them to manually select threaded if they are dead set on that format?

If you change it now, that will be the default for new users. If they already were set to threaded, then it will still be threaded.

I don't know of a way to globally change all users to flat from threaded... probably could be done though. []/forum/images/icons/wink.gif[/]

Hi SDS []/forum/images/icons/smile.gif[/]

Have a look at this link and check out the information at the bottom for page generation time and number of queries used:

https://ubbdev.com/threads/php/...;view=collapsed&sb=5&o=&vc=1

Then look at this link and do the same:

https://ubbdev.com/threads/php/...;view=collapsed&sb=5&o=&vc=1

The threaded view returned to me this information:

Generated in 0.096 seconds. 12 queries. Zlib compression enabled.


The flat view returned this:

Generated in 0.048 seconds. 12 queries. Zlib compression enabled.

Although the generation time for threaded was twice as much as for the flat view they used the same number of queries.

Also, as far as generation time goes thats *darn* quick. (IMHO) []/forum/images/icons/smile.gif[/]

Perhaps you may want to hold on for 6.0 ? []/forum/images/icons/smile.gif[/]

on another forum here the difference was btwn 89 and 10! I wonder why the difference?

never noticed that dave []/forum/images/icons/smile.gif[/] the flat version is 5 times faster in generation times. hmmmm....

ok, a lot of it has to do with the threaded view showing links to all threads... the flat was just to that one page. If you choose "show all", generation times go up to a little more than the threaded view, still less than one third of one second and not bad for a file >700kb []/forum/images/icons/wink.gif[/]

I think Scream reworked the threaded to use less queries but I'm not 100% sure. (actualy I think he redid most scripts to lesson the queries)

To change everyone from threaded to flat you would go to your admin area and send this SQL command to your database:

UPDATE w3t_Users
SET U_Display = 'flat'
WHERE U_Display = 'threaded'



That should put everyone in the same viewing boat. []/forum/images/icons/smile.gif[/]

moral of the story....

for reduced server loads, default to the flat view and keep posts per page ~15 or so... - reduces bandwidth as well. []/forum/images/icons/smile.gif[/]