Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (1)

Resolved Speed of DB Connect/Disconnect

  1. Advice
0
Votes
Undo
  1. Roland Smith
    Roland Smith
  2. PowerBuilder
  3. Friday, 30 August 2019 18:48 PM UTC

I'm doing some timings of an app I am working on that needs to be super fast. It is using a Microsoft Access database currently but in production mode will either be SQL Anywhere or SQL Server.

What is really weird is that the DISCONNECT is taking 3 times as long as the CONNECT. The amount of time is small, 11ms verses 34ms. This could just be weirdness of Access.

Any comments regarding the connect/disconnect process would be appreciated.

I am getting the timings using this function:

Function ulong timeGetTime () Library "winmm.dll"

 

Power builder Classic and TLS 1.2 How to ?
W10 EDGE
Responses (1)
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Friday, 30 August 2019 19:06 PM UTC
  2. PowerBuilder
  3. # 1

Hi Roland;

  FWIW: Access is really a "File Access" product not a full fledged DBMS. I would use a real DBMS like SQL Server for your testing. Then you can also test out the various DB Client's it supports and also various tuning options that you can set the SQLCA's DBParm field.

Just my $0.02

Regards ... Chris

Comment
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.