需要有关数据库问题的帮助. [英] Help required about Database Problem.

问题描述

亲爱的朋友.

我正在VB 2008中开发薪资应用程序，并且正在使用SQL Server 2008数据库(mdf).
在此应用程序中，员工等的图像也将被存储.
我担心随着时间的流逝，数据库文件(mdf)的大小会增长，并且会影响我的薪资应用程序的效率.

我的问题是，当文件(mdf)的大小达到1-2 GB或更大时会发生什么?
我的薪资应用程序会崩溃/挂起或停止吗?

该问题的解决方案是什么，因为我们无法阻止数据库文件的增长.

在这种情况下，请帮助我.

Dear Friends.

I am developing a Payroll Application in VB 2008 and I am using SQL Server 2008 database (mdf).
In this application the images of the employees etc will also be stored.
I am worried that with the passage of time the size of the database file (mdf) will grow up and it will affect the efficiency of my payroll application.

My question is what will happen when the size of the file (mdf) reaches 1-2 GB or larger?
Will my Payroll application crash/hang or stopp working?

What is solution of this problem because we can''t stopp the database file from growing.

Please Help me in this situation.

推荐答案

您正在使用SQL Server2008.1/2 GB的数据库只是一个小问题.如果您的数据库转到TB，您认为会发生什么? SQL Server不会崩溃，不用担心.只需照顾好您的数据库设计，索引等即可.祝您好运.

You are using SQL server 2008. 1/2 GB of database is just a peanut. What do you think will happen if your database goes to TBs? SQL Server will not crash, don’t worry about it. Just take care of your database design, indexes etc. Good luck.

有时候，您需要复制旧数据库-但是要花很长时间. >
更重要的是，事务日志通常会增长得更快.
请参见此处 [

There will be a time when you will need to replicate the old database - but that take a long time.

More importantly, the transaction log often grows much faster.
See here[^] for a tip on how to manage that.

您将不得不担心存储问题空间比数据库大小大.

即使达到100 GB，数据库也不会突然消失，但是随着磁盘空间的充满，您可能会注意到延迟，因此可能会花点钱在更大的存储上. :)

请记住，DB没有存储在RAM中，而是保留在HDD上并进行了轮询.您不必担心.

You will have to worry more about storage space than database size.

The database will not suddenly die if you get to 100 gb even, but you may notice a delay as your disk space fills, so there may come the point of spending some money on larger storage. :)

Remember that the DB is not stored in RAM, it is held on the HDD and polled. you will not have to worry.

这篇关于需要有关数据库问题的帮助.的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！