本文介绍了数据库大小问题的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧! 问题描述 29岁程序员,3月因学历无情被辞! 我们的数据库大小目前为4G,并且以每天45亿美元的价格递增。 SQL数据库的最大大小是多少?什么是 大小超出服务器性能将开始下降?Our database size is currently 4G and is incrementing at a rate of45M/day. What is the max size of a SQL database? And what is thesize beyond which the server performance will start to go down?推荐答案 在什么硬件上? 从我坐的地方你可能已经通过了这一点你只是 我也不知道。 但是直到最终用户开始抱怨我会留在你的位置 做好准备 归档不需要的东西或转移到Oracle,DB2或Informix上 UNIX平台。 - Daniel Morgan http://www.outreach.washington.edu/e...ad/oad_crs.asp http://www.outreach .washington.edu / e ... oa / aoa_crs.asp da ***** *@x.washington.edu (替换''x'''用'u'来回复)On what hardware?From where I sit you''ve probably already passed that point you justdon''t know it.But until end-users start complaining I''d stay where you are whilegetting ready to eitherarchive off what isn''t required or move to Oracle, DB2, or Informix on aUNIX platform.--Daniel Morgan http://www.outreach.washington.edu/e...ad/oad_crs.asp http://www.outreach.washington.edu/e...oa/aoa_crs.asp da******@x.washington.edu(replace ''x'' with a ''u'' to reply) 在什么硬件上? 我坐在哪里你'可能已经过了这一点你只是不知道它。 但是在最终用户开始抱怨之前我会留在原地准备准备好了要么存档不需要的内容,要么在UNIX平台上移植到Oracle,DB2或Informix。On what hardware? From where I sit you''ve probably already passed that point you justdon''t know it.But until end-users start complaining I''d stay where you are whilegetting ready to eitherarchive off what isn''t required or move to Oracle, DB2, or Informix on aUNIX platform. 你说50G SCSI硬盘就像是一个单独的磁盘?任何RDBMS的情况都不是很好 。 我会说你已经远远低于其他RDBMS产品了。可以做。但是,这是不是很重要?直到最终用户开始注意到差异或某些 流程开始花费的时间比窗口允许的时间更长 。 - - Daniel Morgan http://www.outreach.washington.edu/e...ad/oad_crs.asp http://www.outreach.washington.edu/e...oa/aoa_crs.asp da ****** @ x.washington.edu (替换'' x''和'u''回复)You say 50G SCSI hard disk like it is a single disk? Not a goodsituation with any RDBMS.I''d say your are already runnnig far under what other RDBMS productscould do. But doesit matter? Not until end-users start to notice a difference or someprocess starts taking longerthan its window allows.--Daniel Morgan http://www.outreach.washington.edu/e...ad/oad_crs.asp http://www.outreach.washington.edu/e...oa/aoa_crs.asp da******@x.washington.edu(replace ''x'' with a ''u'' to reply) 这篇关于数据库大小问题的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持! 上岸,阿里云!
09-02 22:28