| Author |
Message |
Admin32
Regular
Joined: Sep 14, 2003
Posts: 74
|
 Posted:
Thu Oct 09, 2003 7:55 am |
 
|
Hi people,
Is there any way someone can tweak the SQL queries phpnuke does to the SQL database? I'm having problems again with the SQL users excceding the 36,000 query limit per hour... I cant understand how this is possible with 80 people concurrently online!
Any ideas ? |
|
|
 
|
|
Raven
Site Admin/Owner
Joined: Aug 27, 2002
Posts: 16987
Location: Kansas
|
| Posted:
Thu Oct 09, 2003 8:02 am |
|
It would more than likely involve quite a large rewrite. I can assure you that a 36000 threshhold is VERY SMALL for any site, especially a Nuke site. I guess I'll stick a shameless plug in here, but I don't have any threshhold at Raven Web Hosting  . I have had several people transfer to me for that very reason  |
|
|
 
|
|
Admin32
Regular
Joined: Sep 14, 2003
Posts: 74
|
| Posted:
Thu Oct 09, 2003 8:06 am |
|
Oh yes, I'm aware of the shameless plug I've seen it in my previous posts on your site(!) hehehe.
I've created 5 SQL users, but it seems like its not enough ... after a few reloads, I'll eventually get one of the random 5 users who's queries haven't reached the limit.
Raven, the site is generating around 30Gigs traffic a month from 450,000 page views. Its size it around 250-300 Mb. These numbers are on a constant increase, which really dosen't give me much flexibility when it comes to hosting providers. |
|
|
|
|
|
Raven
Site Admin/Owner
Joined: Aug 27, 2002
Posts: 16987
Location: Kansas
|
| Posted:
Thu Oct 09, 2003 8:10 am |
|
I'm not sure why you don't have much choice. That is not anything out of the ordinary for a reasonably active site. If you want, shoot me a PM on your exact requirements and I'll shoot you back a price. I can handle the traffic w/o any problem. |
|
|
|
|
|
Admin32
Regular
Joined: Sep 14, 2003
Posts: 74
|
| Posted:
Thu Oct 09, 2003 8:19 am |
|
Okies Raven,
I'll pm you with all the details. I'll also need some more info on your hosting server(S), so I'll include all that in the pm.
Cheers, |
|
|
|
|
|
fury
Worker
Joined: Sep 09, 2003
Posts: 165
|
| Posted:
Thu Oct 09, 2003 8:16 pm |
|
I have a question here. My old site was averaging over a million hits per month and not even going over 5Gb bandwith per month, i am wondering of you are gettting harvested or something.
Thanks
Fury |
|
|
|
|
|
Admin32
Regular
Joined: Sep 14, 2003
Posts: 74
|
| Posted:
Fri Oct 10, 2003 2:48 am |
|
Fury,
Most of the bandwidth is being chewed up from my download section.
I;ve got quite a bit of applications, projects and funyn movies which people love to grab.
I might consider removing a few if this becomes a big problem. |
|
|
|
|
|
|
|
|
|
![[Valid RSS]](http://www.ravenphpscripts.com/images/valid-rss.png "Validate my RSS feed"){kind=small}
:: 
::