Board index » delphi » very Very urgent! ibx452, d5e and ib60: Quikreport base on master/details is very slow!
Alberto Salvati
Delphi Developer |
Alberto Salvati
Delphi Developer |
very Very urgent! ibx452, d5e and ib60: Quikreport base on master/details is very slow!2004-07-03 08:47:04 PM delphi102 Hi, list. I've 3 ibquery 1 master and 2 details. I use these ibquery to print a quickreport. These query get data from same table on ib60 database. In this table I have only 160 records. I'm not happy when i execute report, I SEE THAT PAGENUMBER OF QUICKREPORT INCREMENT AND I MUST WAIT 15 MINUTES TO VIEW MY REPORT FULLY PREPARED. If I use 2 of these query with 2 dbgrid, i see that grid refresh is too fast. Why with QuickReport I have this problem? Any ideas? Tnx. Alberto Salvati |
Wayne Niddery [TeamB]
Delphi Developer |
2004-07-03 09:17:34 PM
Re:very Very urgent! ibx452, d5e and ib60: Quikreport base on master/details is very slow!
Alberto Salvati writes:
QuoteI've 3 ibquery 1 master and 2 details. likely solution is to get rid of the master-detail and replace it with a single query that joins the two detail tables. QuickReport should be able to work from that. If you need help with writing such a query, the best group to ask in is borland.public.interbase.sql. -- Wayne Niddery - Logic Fundamentals, Inc. (www.logicfundamentals.com) RADBooks: www.logicfundamentals.com/RADBooks.html In a tornado, even turkeys can fly. - unknown |