Re: Why Access 97 Reports are dozen times faster than Delphi Reports?

Manolis wrote:

[snip performance problems]

I really cannot understand the evolution in the Delphi Reports, and I am
sure that they don't exploit more than 10% percent
of the macines computation capabilities..

I'm really angry and frustrated with this issue.

Here is some suggestions.
1) Use ADO (or is it dbGo now)
2) The default cursor in ADO is serverside forwardonly. Delphi changes this
to some clientside cursor. So change to serverside, forwardonly.
3) _IF_ you eventually uses MS SQLServer, changing cache size to more than 1
will give you a *fast* forward cursor.

I have used access (as well) in some applications, and i _can_ be fast.
So try using a TADOQuery ( that's the name in my D7 Architect), and the
settings mentioned above.
By using clientside cursors, the whole resultset is copied to memory and
maybe locked as well.
It just happens, that i'm playing with Acces97 databases on my server with
ASP/IIS 5.0, and i dont observer any performance problems. Not with
multiple JOIN's as well.
But i only have some 5-6,000 entries by the time being.
Responsetimes is probably < 1 sek, i don't know, but the total turnaround
time for an AJAX driven request appending 506 DOM nodes via .innerHTML
takes < 2 secs. ( On a 750 MHz AMD-something)

So there should be hope for you.

--
Best regards
Stig Johansen
.