*PLEASE READ*
-
zachary.ardBenevolent Dictator
- 1629
Thanks guys. I do plan on donating via Paypal, but was just curious about this -
Our valued Corporate sponsors:
(For information on corporate sponsorship, please check the web forum)Chicks dig me, rust fears me. -
Jason84NA2TSenior Member
- 2909
PLEASE NOTE: There may be momentary lapses in forum accessibility as I make some modifications.
Say goodbye to the spammers!
Search is now enabled. You can only search once every 20 seconds. I am monitoring the load statistics and will compare to yesterday (without search).
zachary.ard wrote:Thanks guys. I do plan on donating via Paypal, but was just curious about this -
Our valued Corporate sponsors:
(For information on corporate sponsorship, please check the web forum) -
1artworkzSenior Member
- 1143
-
Chris86NA2TSenior Member
- 837
z31performance is set as my home page. I often leave my web browser open for long periods of time while logged into the forum. Is this something that bogs things down? I have no idea how this shit works. If it would help to stop doing that please let me know. -
adamvann3Senior Member
- 4160
Your hard core is z31p is your home page. Nice work86na - BlueZ
Shiro #366 - Kouki Monster
85t - Mr Tickles -
sporkliftSenior Member
- 207
It's my home page as well. There is a shitload of amazingly great information on this forum.88 N/A 300zx (Slow....) -
PulseCodeSenior Member
- 1522
THANK YOU Jason. This site has become invaluable to me now that I have begun doing all my own work on my Z. If it ever comes down to it- I would be willing to pay fees to use it. Thanks again man for the hard work. Jeff Z. in SCEverything is Meaningless. -
floridaZSenior Member
- 2781
Jason84NA2T wrote: 4. Doing a lot of things at once, like opening new threads/searches in different windows before others have completed. please avoid doing this.Feedback- viewtopic.php?f=18&t=19840
-
FlawleZSenior Member
- 1971
[quote]floridaZ wrote:Originally posted by Jason84NA2T4. Doing a lot of things at once, like opening new threads/searches in different windows before others have completed. please avoid doing this.That is me right there. I didn't realize that it made a difference if you did them in sequence or all at once.Originally posted by Andrew84zx
tell her your car is so fast it will make her panties fly off
-
Jason84NA2TSenior Member
- 2909
Chris86NA2T wrote: z31performance is set as my home page. I often leave my web browser open for long periods of time while logged into the forum. Is this something that bogs things down? I have no idea how this shit works. If it would help to stop doing that please let me know.
FlawleZ's explaination above is very much correct. Unfortunately part of this issue is that SQL queries appear to run in realtime, which means that multiple queries get stacked into a queue. When someone on the server (me, or other people like with the SQL errors less than an hour ago) run a script that generates a big string of queries from the DB, it clogs up the CPU for a period of time and nothing else can be done on the server until it works its way through the queue. I know there are some number of ways out there to allow prioritization of these individual queries (so one script cannot hog the entire cpu, the processing is shared), but I don't know the rest of the details, don't own the box, and I'm also not about to tell the hosting company what to do when they have been so (relatively) accommodating already. -
phxZ31Senior Member
- 598
[quote]Jason84NA2T wrote:Originally posted by Chris86NA2Tz31performance is set as my home page. I often leave my web browser open for long periods of time while logged into the forum. Is this something that bogs things down? I have no idea how this shit works. If it would help to stop doing that please let me know.
Nope, that's not really an issue. I guess the simplest way to explain is that load is incurred whenever you click and your browser loads something. This is especially true of anything that uses the search feature, as it combs through a section of the DB indexes looking for specific information.
FlawleZ's explaination above is very much correct. Unfortunately part of this issue is that SQL queries appear to run in realtime, which means that multiple queries get stacked into a queue. When someone on the server (me, or other people like with the SQL errors less than an hour ago) run a script that generates a big string of queries from the DB, it clogs up the CPU for a period of time and nothing else can be done on the server until it works its way through the queue. I know there are some number of ways out there to allow prioritization of these individual queries (so one script cannot hog the entire cpu, the processing is shared), but I don't know the rest of the details, don't own the box, and I'm also not about to tell the hosting company what to do when they have been so (relatively) accommodating already.
We have a 10GB SQL database for a massive product catalog, and the main server doing all the work is a ten year old, dual CPU Pentium 3 933mhz machines with 2GB of single channel, single datarate SDRAM. We have over 300 employees' client PCs constantly making queries, searching the DB, modifying entries, etc, all day long. The business depends on the database running. The same server is also an active directory domain controller hosting roaming windows profiles, functions as a DNS server, and has routing and remote access enabled to control IP traffic to a private internal network.
It seems odd to me that I can do so much with a 10 year old server and it doesn't even give hints of complaining about it, yet this forum with a relatively tiny SQL database size and probably relatively moderate traffic should be so crippling. The problem must be with bots or other software on the forums. Do you have any programs running that constantly monitor your SEO rankings, back links, google optimizations, and stuff like that? I've heard of those types of tools causing problems like this..
Are they sure they can definitively link the resource hogging to the thread/s running this board?1985 300ZX N/A -- Schneider Racing Cams + Valve Springs - U/R Underdrive Pulley - Ported/Polished Heads -
MSA Headers - MGP Intake Manifold - K&N Air Filter - Electric Cooling Fan -
-
Rat1314Senior Member
- 451
my computer picked up 2 Trojan viruses when I was looking in the Z31 turbo modifications FAQ and The truth about Ebay turbochargers. I only had one page up at a time and I had my virus software notify me of a virus each time.Originally posted by TearingRavenHonestly, if you have to ask this question and common sense does not kick in immediately, you need to be riding the bus. Preferably while wearing a helmet.