Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 7 of 7 total
Thread Performance
Tue, Mar 13 2007 5:20 AMPermanent 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 AMPermanent 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 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate 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 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email 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 AMPermanent 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 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Sachith


It simply the pdf manual that comes with dbisam

Roy Lambert
Wed, Mar 14 2007 6:21 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email 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

Image