I understand 8.1 is an ancient ADS version and hopefully my client updates one day soon. But the scenario is.. when we are running an annual report locally on the server, it takes about 60 seconds. And when running the same report over the network, it takes about 4 mins (Gigabit network).

So I understand this database won't utilize the speed of our server and is probably just capped at running this speed for whatever reason, but is there anything I can do to have it run faster over the network, closer to the 60 seconds it takes to run it locally.

Note: -When watching the Resource Monitor in Windows 7 (PC client), while running this report, the Network transfers at about 47Mbps when connected via Gigabit, and 21Mbps when connected via 100MB. -I set the Windows power plan to High Performance since I found a thread about that FYI.

asked 26 Mar '15, 23:53

clint25n's gravatar image

clint25n
11113
accept rate: 0%

edited 26 Mar '15, 23:56


Without any knowledge about how and using which technology your report is generated this question is hard to answer.

Some pointers:

Normally you should do as much work using SQL on the server side and only transfer the results to the client, so only the result has to be send over the network.

That said, you could of course generate your report on the server as a file (say PDF or whatever format suites your needs best) and make the file available to the user via a file share or HTTP, etc.

link

answered 27 Mar '15, 08:19

Jens%20M%C3%BChlenhoff's gravatar image

Jens Mühlenhoff
1.3k51037
accept rate: 18%

Yea thanks. All I really know is that while running one of the long reports, the CPU and Disk are taxed less than 1% on the client side and server, and the network maxes out at about 5% (47Mbps). So since the same report at least runs 5x faster locally on the server when it doesn't have utilize the network card/speed, I assumed this database software has some sort of resource ceiling where it cannot really utilize today's hardware/resources.

Perhaps I'm wrong, but just in case it helps, I've attached a couple screenshots of my ADS configuration tabs. And thanks for your earlier response!

alt text alt text

link

answered 27 Mar '15, 10:39

clint25n's gravatar image

clint25n
11113
accept rate: 0%

I would try a couple of things with ADS 8.1

1) Turn on aggressive caching when doing the reports. In C++ code,
AdsTable1->AdsTableOptions->AdsRecordCache=rcAggressive;

2) Turn on compression. On the server using the ADS configuration program, it is under the "Configuration utility, Communications tab. Set Compression to "Always".

3) Ensure your ads.ini file has the IP address and port number of the ADS server stamped into it, and that it exists in the same directory as your application doing the reports. Also, make it use TCPIP instead of the default UDP. For example,

[192.168.254.212]
LAN_IP=192.168.254.212
LAN_PORT=6262

[Settings]
USE_TCP_IP=1

For me, this ramps up performance.

link

answered 09 Apr '15, 05:32

ADS%20Veteran%20MJ's gravatar image

ADS Veteran MJ
2765717
accept rate: 8%

Your answer to the original question.
If responding to a request for additional information, please edit the question or use the comment functionality.
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "Title")
  • image?![alt text](/path/img.jpg "Title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Tags:

×17
×3

Asked: 26 Mar '15, 23:53

Seen: 1,552 times

Last updated: 09 Apr '15, 05:32

Advantage Developer Zone Contact Us Privacy Policy Copyright Info


Powered by Advantage Database Server and OSQA
Disclaimer: Opinions expressed here are those of the poster and do not necessarily reflect the views of the company.