如何配置Firebird数据库以在内存中运行 [英] How to configure a Firebird Database to run in memory

问题描述

我正在运行一个名为Fishbowl清单的软件，并且它正在Firebird数据库(Windows Server 2003)上运行，这时，如果有一个以上的用户访问该软件，fishbowl软件的运行速度将非常慢.我想我也许可以通过强制数据库在内存中"运行来加快应用程序的速度.但是，我找不到有关如何执行此操作的文档.任何帮助将不胜感激.

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 thinking I maybe able to speed up the application by forcing the database to run "In Memory". However I can not find documentation on how to do this. Any help would be greatly appreciated.

先谢谢您. 罗伯特

推荐答案

Firebird没有内存表-它们可能会或可能不会在将来的版本(> 3)中添加，但肯定不会在即将发布的2.5中添加.可能有许多其他原因导致您的软件在多个用户中运行缓慢.但是，Firebird本身具有很好的并发性，因此请确保首先找到实际的瓶颈.

Firebird does not have memory tables - they may or may not be added in future versions (>3) but certainly not in the upcoming 2.5. There can be any other number of reasons why your software is slow with multiple users; however, Firebird itself has pretty good concurrency, so make sure you find the actual bottleneck first.

这篇关于如何配置Firebird数据库以在内存中运行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！