The current memory is cheap, and the servers with 16 GB memory or above are already quite common. The large memory indeed speeds up the running of your server. However, some analysis reports generate n
The data in the table is inverted, from which the table is total to which table. this process may affect normal services. slowing down Server Response
Time required. As we all know, the memory access speed is much faster than the hard disk. At this time, we can do something in the memory.Article:
1. Download a ramdisk or quasi-software, first Virtualize it into a hard disk at around 2 GB of memory.
2. Create an empty database on your physical hard disk (it is impossible to create a database directly on the Virtual Disk). Set the transaction mode of this database to simple.
3. Separate the new database.
4. Copy the database to your virtual disk and attach it.
I tested on my computer: l730t + 2G + 320g.
There are about 1 million insert into records per second, and the data is very stable.
OK, your memory database is complete.
In the future, any temporary intermediate table pulled from the analysis report can be stored in this library and kill after use, or you have a lot of real-time data to collect, also put in this library (pay attention to writing back to the object table every certain time, but also pay attention to power failure .)
From: http://www.cnblogs.com/gyxdbk/archive/2011/11/19/1430246.html
