Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM Client/Server » View Thread |
Messages 1 to 9 of 9 total |
Set server parameters to better performance |
Fri, Apr 13 2007 7:52 AM | Permanent Link |
Durumdara | Hi!
We have DBISAM Servers (version 3.3) in many places. Sometimes we need to get better performace. In other database servers (like FireBird, MS-SQL) we can set many parameters to increase performance (make better speed). Like "pages hold in memory", "auto memory allocation", "proc. affinity", etc. Which parameters can I set in this version of the dbisam server? Have this server any hidden parameters that not configurable from administration application? (Like memory pages, etc.). We must speed up one server, and we must check the possibilities of the software performance increasing before we pay for better hardware. Thanks for your help: dd |
Sat, Apr 14 2007 3:06 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | << We must speed up one server, and we must check the possibilities of the software performance increasing before we pay for better hardware. >> The best way to increase performance is to recompile the DBISAM database server with FastMM 4 included. The default memory manager for Delphi that DBISAM uses is pretty bad with multi-threading performance, especially on a multi-processor machine. -- Tim Young Elevate Software www.elevatesoft.com |
Sat, Apr 14 2007 3:34 PM | Permanent Link |
Charalabos Michael | Hello Tim,
> The best way to increase performance is to recompile the DBISAM database > server with FastMM 4 included. The default memory manager for Delphi that > DBISAM uses is pretty bad with multi-threading performance, especially on a > multi-processor machine. If i remember correctly i suggested to you to compile the dbisam servers of all delphi editions with delphi 2006 (or better now with 2007). So, since delphi 2006/2007 has fastmm built in it would give the best perfomance of the server. (of course not using DBISAM's MM) Aren't doing that now ? eg. Delphi 7 installation contains a server compiled with delphi 7 ? If that's the case then i would download Delphi 2007 installation and use it's server .... Am i clever or what ... -- Charalabos Michael - [Creation Power] - http://www.creationpower.gr |
Mon, Apr 16 2007 5:25 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Michael,
<< If i remember correctly i suggested to you to compile the dbisam servers of all delphi editions with delphi 2006 (or better now with 2007). So, since delphi 2006/2007 has fastmm built in it would give the best perfomance of the server. (of course not using DBISAM's MM) Aren't doing that now ? >> No, DBISAM 4.x still uses its own memory manager and all servers are compiled with Delphi 5. -- Tim Young Elevate Software www.elevatesoft.com |
Tue, Apr 17 2007 4:08 AM | Permanent Link |
durumdara | "Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote:
<< We must speed up one server, and we must check the possibilities of the software performance increasing before we pay for better hardware. >> > >The best way to increase performance is to recompile the DBISAM database >server with FastMM 4 included. The default memory manager for Delphi that >DBISAM uses is pretty bad with multi-threading performance, especially on a >multi-processor machine. So there isn't way to increase memory buffers, or other parameter used by server? Please help me a little. If I see good, the server is only a multithreaded brige across the net. It is seems to be a remote object that handle connections as local embeddeb library, but it is working local, and send/receive results through the net... I see this thing good? thanks for the infos: dd |
Tue, Apr 17 2007 6:48 AM | Permanent Link |
"Jose Eduardo Helminsky" | Tim
Why don´t you change DBISAMM to FASTMM in version 4 ? Always I´ve upgrade to a new build, I have to recompile the server changing the memory manager. And I think this situation is common for many users. Eduardo |
Tue, Apr 17 2007 7:57 AM | Permanent Link |
Arnd Baranowski | Eduardo,
no it is not. I use DBISAM or Nexus Memory Manager Arnd Arnd Jose Eduardo Helminsky wrote: > Tim > > Why don´t you change DBISAMM to FASTMM in version 4 ? Always I´ve upgrade to > a new build, I have to recompile the server changing the memory manager. And > I think this situation is common for many users. > > Eduardo > > |
Tue, Apr 17 2007 11:19 AM | Permanent Link |
"Jose Eduardo Helminsky" | Arnd
But **IF** FastMM is better than DBISAM memory manager and it is free then... I don´t know Nexus MM but if it is better than FastMM and it is free, then that is the way. Eduardo |
Tue, Apr 17 2007 5:32 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | << So there isn't way to increase memory buffers, or other parameter used by server? >> Yes, you can do so by modifying the memory buffer parameters on a per-session basis. See the documentation for the TDBISAMSession component provided with the product. << Please help me a little. If I see good, the server is only a multithreaded brige across the net. It is seems to be a remote object that handle connections as local embeddeb library, but it is working local, and send/receive results through the net... I see this thing good? >> Yes, you're pretty much correct. That's how it works as a basic description. However, DBISAM is not just a code library, it is a complete database engine. -- Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Tuesday, September 17, 2024 at 04:19 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |