| Author |
Thread Statistics | Show CCP posts - 2 post(s) |
Andrue
Amarr
   |
Posted - 2006.09.03 20:22:00 -
[1]
 Originally by: Mongrove
Originally by: Valar
We are keeping a close eye on the situtation.
Thx Valar  for the quick answer, and thx guys for the BMs copying 
I think you should limit the number of BMs by character, 900k BMs is just insane 
140k accounts so that's an average of less than 9BMs per account. Hardly insane. 
--
(Battle hardened miner)
[Brackley, UK]
WARNING:This post may contain large doses of reality. |
Andrue
Amarr
|
Posted - 2006.09.03 21:58:00 -
[2]
Originally by: Price Watcher
3. Make it work on autopilot.
What in blazes for? Autopilot should remain as it is. Warp to 0 replaces the instas that everyone already has so it doesn't make any practical difference.
But warp to 0 for autopilot? That's stupid. If you fly afk you should be vulnerable. If you put the effort in and stay at your keyboard you benefit from reduced risk travel.
--
(Battle hardened miner)
[Brackley, UK]
WARNING:This post may contain large doses of reality. |
Andrue
Amarr
|
Posted - 2006.09.03 22:03:00 -
[3]
Originally by: SonShadowCat
It's nice to see people continue to copy BM even though they know they're destroying the server and gameplay for everyone else.
What do you think they are going to do? This game is a community of human beings and they will exploit it the way humans always do. You can't just tell people not to do something and expect that they will comply.
Only a fool and at least one government I'm all too familiar with would believe otherwise.
--
(Battle hardened miner)
[Brackley, UK]
WARNING:This post may contain large doses of reality. |
Andrue
Amarr
|
Posted - 2006.09.04 11:54:00 -
[4]
Originally by: syphurous
I beleieve you should only be recording XYZ and the system your in. Thats 4 varibles, which could be contained in a simple string.
There is nothing 'simple' about a string. Generating the textual representaton of a number takes time. Obtaining the numeric value of a string takes even longer. Storing strings is a PITA because they are variable length.
--
(Battle hardened miner)
[Brackley, UK]
WARNING:This post may contain large doses of reality. |
Andrue
Amarr
|
Posted - 2006.09.04 11:57:00 -
[5]
Originally by: Malachon Draco
Is it a problem of data transfer or of finding the data in the DB in the first place? I can understand the data amount is pretty damn small. But finding the data takes just as long whether its 1kb or 1MB, doesn't it?
(Not a DB expert here), but I would imagine that 1000 queries for 1kb worth of data is a hell of a lot worse on a DB than 1 query for an 1mb data item.
Yes. A golden rule of database work (except perhaps for local databases where the database engine is integral to the application) is to minimise the number of queries being made. It's often called batch processing.
Size is a factor but most of the time the overhead in transmitting and responding to a query exceeds the 'cost' of the actual data transfer.
--
(Battle hardened miner)
[Brackley, UK]
WARNING:This post may contain large doses of reality. |
| |
|