Originally by: Ser Prius

---

The correct answer is for CCP to buy the hardware necessary to run their application. Right now the nodes are vastly underpowered for 700 ships in a system. They should invest in a rack of supercomputer level nodes for fleet battles, if a node gets over say 50-100 ships undocked they should swing it over to one of the supercomputer nodes. By supercomputer I mean something like this this.

---

Originally by: Tarminic

---

Originally by: Dark Shikari

---

One idea would be, to reduce database transactions, load everything from the database that matters for combat/etc into the memory of the node for everyone in the system. Delay all transactions back to the database server so that they can be done in bursts, to minimize the total number of transactions. Don't read from the database when possible, instead read from the memory.

---

That's actually a pretty damn good idea, DS. The question remain as to whether the servers can support the internal memory that would be required of them, and that given the amazingly fast access speeds of the RAMSAN drive, how much of a performance increase would this actually provide?

---

Originally by: Tarminic

---

It would have to be server memory - caching all of the required data on the client's computer would only cause more lag, and you would also have to worry about people manipulating that cached memory or running making sure it hasn't been tampered with.

---