Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM Client/Server » View Thread |
Messages 1 to 7 of 7 total |
Performance |
Tue, Mar 13 2007 5:20 AM | Permanent Link |
Sachith Gunawardane | Hi Tim,
We are currently facing some performance issue in our apps. Its developed using D5 & DBISAM 3.24. We are using it with DBISAM server (DBSRVR). One of the things I found out because we use DBISAM server to connect DB all the temp tables created on the server. So each time client access temp table request goes to server. My question is if I create some temp tables in client end using different session and access other DB tables and temp tables using DBISAM server, will I face any problem??? Is there is any other way to overcome this. |
Tue, Mar 13 2007 8:03 AM | Permanent Link |
Allan Brocklehurst | Sachith Gunawardane wrote:
> Hi Tim, > > We are currently facing some performance issue in our apps. Its developed using D5 & DBISAM 3.24. > We are using it with DBISAM server (DBSRVR). One of the things I found out because we use DBISAM server to connect DB all the temp tables > created on the server. So each time client access temp table request goes to server. > My question is if I create some temp tables in client end using different session and access other DB tables and temp tables using DBISAM server, > will I face any problem??? Is there is any other way to overcome this. > Sachith; Hi. Make sure the server is defragged. Creating temp tables, SQL calls etc. really frags the disk allot, as you know. Also add the fastmm unit(s) oe some memory manager as a part of the executable, if not there already. you will see great preformance results Allan |
Tue, Mar 13 2007 9:14 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Sachith
>My question is if I create some temp tables in client end using different session and access other DB tables and temp tables using DBISAM server, >will I face any problem??? That is one of the main strengths of DBISAM you can have mixed c/s and fileserver access without any problems.. There are a few tips in the manual and on these ngs for improving c/s performance the main one of which is to reduce network traffic. Good luck Roy Lambert |
Tue, Mar 13 2007 6:38 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Sacith,
<< We are currently facing some performance issue in our apps. Its developed using D5 & DBISAM 3.24. We are using it with DBISAM server (DBSRVR). One of the things I found out because we use DBISAM server to connect DB all the temp tables created on the server. So each time client access temp table request goes to server. My question is if I create some temp tables in client end using different session and access other DB tables and temp tables using DBISAM server, will I face any problem??? >> No, that will work just fine as long as you use a separate, local session. -- Tim Young Elevate Software www.elevatesoft.com |
Wed, Mar 14 2007 1:20 AM | Permanent Link |
Sachith Gunawardane | Roy Lambert <roy.lambert@skynet.co.uk> wrote:
That is one of the main strengths of DBISAM you can have mixed c/s and fileserver access without any problems.. There are a few tips in the manual and on these ngs for improving c/s performance the main one of which is to reduce network traffic. Hi Roy, Can you please send me the manual that u refer. Sachith |
Wed, Mar 14 2007 4:05 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Sachith
It simply the pdf manual that comes with dbisam Roy Lambert |
Wed, Mar 14 2007 6:21 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Sachith,
<< Can you please send me the manual that u refer. >> See this FAQ item: http://www.elevatesoft.com/dbisam_faqt_1.htm -- Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Thursday, March 28, 2024 at 06:05 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |