Re: Why Access 97 Reports are dozen times faster than Delphi Reports?
- From: yannis <none@xxxxxxxxxx>
- Date: Fri, 29 Feb 2008 11:01:35 +0200
After serious thinking Manolis wrote :
Hi,
I've also nearly 400 ReportBuilder reports.
90% of my application hungs are due to Report Builder.
I have cases like the one I try to optimize that a Report Builder
report opens at 30 seconds while the same Access report opens at 3 seconds.
I also purchased Fast Report in order to replace RBuilber for some reports
with many contols but the results were not better.
From the 400 reports I designed in RB I don't think that I would have problems designing
in Access97 to more than one or two.
I don't actually think that the enhancments in the new reports compared to MsAcces97 are
really significant and there are some of MsAccess97 features that these new report engines lack,
especially if you want to design a report with many controls and borders. This can be done many times
faster in MsAccess.
Therefore my assumptions and thoughts are different than yours..
Manolis Perrakis
"Alexandre Machado" <alexandre@xxxxxxxxxxxxxxxxxxxx> wrote in message news:47c71dd2@xxxxxxxxxxxxxxxxxxxxxxxxx
It is so silly, and I feel so stupid that I cannot compete with MSAccess 97
reports with either Report builder of
Fast Reports. Especially with complex reports and many pages the difference in speed is outrageous.
QuickReport 1 (I still have it in a museum with my Delphi 1.0 ;-) ) is 20 times faster than any other Delphi reporting tool I've used, but it is not better.
Word for Windows 2.0 (16 bits) is 1000 times faster than Word 2003, but it is not better. Every new version gets slower, this is a fact, because more features are added to the product.
I've used MS Access 97 and you just CAN'T build complex reports I usually build with Report Builder.
that most of the the times my applcation hungs completely when using Report Builder with no specific reason and can be terminated only by the
task manager. Many of the users however don't have the knowledge to do this and they reset their machines.
I've used ReportBuilder since 2001 (version 5 then, I think), and I can assure you that it is rock solid. I've never seen an access violation for instance within RB code. I have hundreds or complex reports in a few applications.
Regards,
Alexandre Machado
Lets see.
A few facts that you have to consider before blaming the report engine.
1) except from access you have changed the DB as well from a file based
to an SQL server.
2) You do not use a reporting engine inside the database engine, this
meens that the reporting can not have inside on the data (number of
rows, lenght of each column etc)
3) You have not break the proccess down to its steps to identify the
bottle neck or it seems so from your post.
In short. Take a look on Stig Johansen post. It is the one addressing your issue and surfacing your actual problem.
regards
Yannis.
PS.
Να υποθέσω (από την ώρα αποστολής του μυνήματος) ότι δεν το τσίκνισες εχθές.
--
The nice thing about being a celebrity is that if you bore people they think it's their fault.
- Henry Kissinger (1923-)
.
- References:
- Why Access 97 Reports are dozen times faster than Delphi Reports?
- From: Manolis
- Re: Why Access 97 Reports are dozen times faster than Delphi Reports?
- From: Alexandre Machado
- Re: Why Access 97 Reports are dozen times faster than Delphi Reports?
- From: Manolis
- Why Access 97 Reports are dozen times faster than Delphi Reports?
- Prev by Date: Re: ZoneAlarm????
- Next by Date: Re: 5 millions lines of code - too many
- Previous by thread: Re: Why Access 97 Reports are dozen times faster than Delphi Reports?
- Next by thread: Re: Why Access 97 Reports are dozen times faster than Delphi Reports?
- Index(es):
Relevant Pages
|
