https://www.icyphoenix.com/viewtopic.php?f=35&t=38&p=192#p192
-----------------------------------
Tom
Fri 11 Aug, 2006 19:44

Re: Excesive Consume Of SQL Recurses
-----------------------------------
MG posted an article on XS.com a while ago on how to reduce database load. However, in order to set it up, you need access to the ACP.

Let's see if I can put it back together:

[b]ACP -> Configuration -> Database[/b]
[list][*][b]Disable Logins Recording:[/b] [color=green]Yes[/color]
[*][b]Database Optimize:[/b] [color=red]No[/color] (can be done manually, if needed)
[*][b]Site History:[/b] [color=red]No[/color] (Extended statistics that should be disabled)
[*][b]Caching of the board's Configuration:[/b] [color=green]Yes[/color][/list]
[b]ACP -> Configuration -> XS[/b]
[list][*][b]Protect Main Admin Account:[/b] [color=red]No[/color]
[*][b]Deactivate Force Topic Read:[/b] [color=green]Yes[/color][/list]


