Decreasing queries on website?: WSN Support

Version: 3.14

Decreasing queries on website?

fuee
Forum Regular

Usergroup: Customer
Joined: Nov 01, 2004
Total Topics: 56
Total Posts: 121

Posted 03/16/05 - 03:25 PM:	#1
1) Powweb now has a limitation on how many queries your database may have per hour. It's set at 72,000 queries/hour. That does not seem like much if Each page at my site generates 75 queries with 100 visitors/hour and 10 page views/visitor then I would hit 72,000 queries. Are there any techniques for me to decrease my querie count on my site with in WsnLinks? 2) does templates html codes like reciprocal link increase query time even though I have it turn off under switches, or should I remove any unnecessary html codes that I am not using for my site to decrease query time. 3) Does using CSS increase, decrease or have no effect on query time? Thanks, Fuee Edited by fuee on 03/16/05 - 03:42 PM

Paul
Administrator

Usergroup: Administrator
Joined: Dec 21, 2001
Location: Northern California
Total Topics: 57
Total Posts: 6339

Posted 03/17/05 - 04:23 PM:	#2
I find that a rather nutty policy since queries are not created equal and things that lower the number of queries don't always lower the load. Anyhow, toplists are the main thing I can think of that increase query totals. Link types use extra queries only if you've selected in your settings to not mix link types. I don't remember there being any way to switch off link types though so I don't know what you're really talking about. CSS has nothing to do with mysql.
"Do things you love doing, because then it ain't work. Don't do something you don't really enjoy, because you're never going to work hard enough at it." - Bob Young, founder of Red Hat

fuee
Forum Regular

Usergroup: Customer
Joined: Nov 01, 2004
Total Topics: 56
Total Posts: 121

Posted 03/17/05 - 05:34 PM:	#3
thanks Paul for your reply. You should set up a hosting company Paul. Ill definitely sign up . Thanks again, Paul

Paul
Administrator

Usergroup: Administrator
Joined: Dec 21, 2001
Location: Northern California
Total Topics: 57
Total Posts: 6339

Posted 03/18/05 - 07:06 AM:	#4
I wouldn't. I've been running a site on a VPS since last August (a VPS acts like a dedicated server with full OS access, but it's actually a partition embedded in a larger server hence it's much cheaper) and found that all I seem to know how to do is click the 'reboot' button when something goes wrong. Webmastersite.net's host Spenix is certainly the most flawless host I've been with. Run by the creator of webhostingtalk.com.
"Do things you love doing, because then it ain't work. Don't do something you don't really enjoy, because you're never going to work hard enough at it." - Bob Young, founder of Red Hat

You don't have permission to post.