多用户大数据量的数据库访问优化与设计

Access optimization and design of database with multi-user and mass data

文章首先介绍了当前较为流行的ADO.NET数据库访问模型,以此为基础,设计了一套综合运用数据库连接池和存储过程的数据库访问方法,并通过程序代码的巧妙改进有效地提高了批量操作时的访问速度。目前,该方法已经在某珠宝销售公司的货品仓储和销售管理信息系统中得到应用,效果良好。

In this paper ,ADO .NET ,the current popular database access model ,is introduced .Then a database access method w hich makes a comprehensive use of stored procedures and database connec‐tion pool is designed .Through the clever improvement of program code ,the access speed of the batch operation is effectively improved .Currently , this method has been applied effectively in the goods warehousing and sales management information system of a jewelry sales company .