用于多处理器的Firebird数据库调整 [英] Firebird database tuning for multiprocessor

问题描述

我正在运行一个称为Fishbowl清单的软件，并且它在firebird数据库(Windows Server 2003)上运行.这时，当一个以上的用户访问该软件时，鱼缸软件的运行速度非常慢.我想知道是否有人可以提供有关调整数据库或最佳实践的信息?我们目前正在运行具有4 gig内存的Dell Power Edge 2700双四核.任何帮助将不胜感激.

I'm running a software called Fishbowl inventory and it is running on a firebird database (Windows server 2003). At this time the fishbowl software is running extremely slow when more then one user accesses the software. I'm wondering if anyone could provide some information on tuning the database or best practices? We are currently running a dell power edge 2700 dual quad core with 4 gig's of ram. Any help would be greatly appreciated.

先谢谢您.罗伯特

推荐答案

我确实报告了Fishbowl库存(2009.1-2010.2)的开发，并且我的业务伙伴是Fishbowl VAR.我们已经与数据库处理速度慢的客户打交道. o在fishbowlreports dot com上给我ilopez喊一声

I do report development for Fishbowl Inventory (2009.1-2010.2) and my business partner is a Fishbowl VAR. We have dealt with customers with slow databases. oGive me a shout at ilopez at fishbowlreports dot com

奇怪的是，具有这些规格的服务器显示出滞后，但这并不是闻所未闻的.

It is odd that your server with those specs is showing lag, but It is not unheard of.

需要牢记的三件事

1)数据库大小-数据库越大，处理报表/更新等时数据库必须处理的行越多. 2)活动-服务器上的某些活动很重 3)版本-较新的鱼缸版本在表上具有附加索引，从而可以加快查询速度

1) Database Size - The larger the db, the more rows it has to deal with when working on reports/updates, etc. 2) Activities - Certain activities pound on the server 3) Version - The newer fishbowl versions have additional indexes on the tables, which allow faster queries

根据我的经验，大多数任务会随着工作的完成而线性增加.请参阅: http://www.fishbowlinventory.com/forums/viewtopic.php?f = 16& p = 5240 -我对Fishbowl广告资源2009.3进行了一些基准测试，希望在Fishbowl 2010.2中也做同样的工作(一旦发布).

In my experience most of the tasks increase in time linearly by the work done. see: http://www.fishbowlinventory.com/forums/viewtopic.php?f=16&p=5240 - I did some benchmarking on Fishbowl Inventory 2009.3, hope to do the same in Fishbowl 2010.2 (Once it is released).

-以色列

这篇关于用于多处理器的Firebird数据库调整的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！