Trigger64
   |
Posted - 2006.09.01 18:39:00 -
[1]
/me puts on a fire resistant suit and activates his thermal resists
Well actually I like the idea. What [most of] you people don't realize is how CPU hungry the BM's really are. I assume that CCP is MS-SQL as their database, and what I don't think people realize is that every time you copy a BM that BM has to be queried from the database, stored in memory, a new one is created and added to the DB.
Every book mark that needs to be copied, needs to un a seperate "SELECT * from Bookmarks WHERE $ID = "#############" (or how every they catalog them) query. a "INSERT INTO Bookmarks WHERE $user = "your_user_name" and then a loop to go back to the selection query.
What really happens is that the BM's are not actually shown on your screen until the entire loop has completed. So if you've got 500 bookmarks to copy, you have to wait until the select -> insert new (duplicate) query has been run.
Which is why it's faster to copy small sets of BM's than the large ones, because you'd only have to wait for 10 or so to copy.
Don't forget that each query that is run into the DB requires CPU, because they're all seperate processes. Now multiply your 500 BM query by say... 2,000 on a busy day to cover the 1/10 of the server that might be copying bookmarks. thats 1,000,000 processes. Anyone who doesn't see that as a problem is either an idiot or has never had their computer lock up because they tried to do too much at once.
The differance between CCP's servers and your home computer is the servers enter a failsafe mode when they reach a pre-determined thresh hold on CPU use. At which point they probably start trimming back non vital processes (entrances into congested systems anyone?) and if that fails, the hampster has permission to take a water break.
So please. Don't yell at CCP because you can't crash their servers in-advertantly anymore.. Just plan accordingly!
Remember that EVERYTHING that exists in the game is part of a table somewhere in their massive database. So when you wonder why it takes so dang long for your corp hanger to open. It's because everything in there has to be called from the database. Same reason for BM's not showing in the corp hanger or your hanger or in the cans. They have to complete the Select and (for you PHP people) echo loop(s) COMPLETELY before they are displayed.
That said I wouldn't mind the max BM copy ammount being bumped to 10 or 25 
|