Today, the big memory cost has been completely can withstand. Google use a lot of PC establish cluster in data processing, and I have been think, to use big memory PC can be low cost solutions in the middle of the front even load problem. Due to the PC hard disk life is short, slow, the CPU is a bit slow, used for web front end are cheap, and can give full play to the advantages of large memory, and bad words only need to replace can, do not exist the transfer of data. Office 2010 is new for you.
Below is the design of the application. Application shall be in the design as far as possible into the design of the support extensible database design, database can be added, also support the dynamic memory cache, such is the lowest cost. Another application design method is to use the middleware, such as ICE. The advantages of this scheme is front application can design of relatively simple and data layer for front application by ICE, transparent, provide the design of distributed database in the end, the use of ICE to realize shipped to front application to use, this way of each part of the design requirement of design is low, will better layered, but business due to introduction of middleware, points more multilayer, realize up cost is relatively high.
Microsoft Office 2010 is ready to help your work..
In the design of the database on the one hand we can use cluster, on the one hand, grouping. At the same time in detail the principle of optimization will database application as far as possible, The Office 2007 software makes work so easy.
database structure and data layer on the design application to avoid as far as possible to create temporary table, the dead lock production. The principle of database optimized in online is more familiar, many Google once can solve the problem. In a database on the choice of the habit of it according to their choice, Oracle, MySQL, Oracle is not solve all problems, not just on behalf of small application, MySQL right is the best.