| Subject | RE: [firebird-support] Cumulative queries |
|---|---|
| Author | Bogdan |
| Post date | 2015-03-12T07:44:46Z |
Are you running superserver ?
If so i would recommend switching to classic or superclassic
Regards
Bogdan
From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Sent: Thursday, March 12, 2015 8:06 AM
To: firebird-support@yahoogroups.com
Subject: Odp: [firebird-support] Cumulative queries
Hi,
This look for me like wrong design.
Query running minutes are not acceptable from my POV.
I do not know how your system work, but in any stock system i see month work. Month is closed and data are calculated and stored. And in next month the same
Regards,
Karol Bieniaszewski
----- Reply message -----
Od: "'Tiberiu Horvath' tiberiu_horvath@... [firebird-support]" <firebird-support@yahoogroups.com>
Do: <firebird-support@yahoogroups.com>
Temat: [firebird-support] Cumulative queries
Data: czw., mar 12, 2015 07:19
Hi all,
I have a Firebird stock management system with 100+ tables and 10+ clients. I have some cumulative queries in my Delphi program that generates reports. My problem is that while the queries are run (less than 5 minutes each), the whole system performance is poor, people complaining about the speed of the database. How do you deal with this ?
Thinking about :
1. Create a backup database and have the queries run there (backup / restore during the night) ? This would be the obvious option. If data for the reports is one day behind the real system is not a big problem.
2. In FireBird do I have some switch to lower the priority of a query ?
select * from table –low priority mode-
some other ideas ?
Thank you in advance ,
Tiberiu
|
Ta e-pošta je bila pregledana z Avast protivirusnim programom.
|