Slow compiling

rbuser

I have three tables combined into one, but with only 8 fields from the
three tables.
However with any sizeable DB the report takes forever to run. Well with a
tiny db it takes up to 5 sec. With a large db, I have left it for 20 mins
and it still doesnt compile in preview.
I have isolated the problem to the tables (rather than the groups or
variable calcs).
Because when I do a table preview in DATA tab, the same thing happens. It
seems to stall and takes way too long to be useable.

Here is the SQL code. Any suggestions?

SELECT REMARK_1.ATA, REMARK_1.REMARK,
COMPHIST_1.IO_ACTION, COMPON_1.NAME,
COMPON_1.PN, COMPON_1.SN, COMPON_1.TSN,
COMPON_1."TYPE" TYPE_2
FROM REMARK REMARK_1
LEFT OUTER JOIN AIRCRAFT AIRCRAFT_1 ON
(AIRCRAFT_1.KEY_NO = REMARK_1.KEY_NO)
INNER JOIN COMPHIST COMPHIST_1 ON
(COMPHIST_1.TRACKINGKEY = REMARK_1.REMARK_KEY)
RIGHT OUTER JOIN COMPON COMPON_1 ON
(COMPON_1.KEY_NO = REMARK_1.COMPONENTKEY)
WHERE ( REMARK_1.REMARK = 1 )
AND ( COMPHIST_1.IO_ACTION = 'O' )
ORDER BY AIRCRAFT_1."TYPE"

Thanks
Redmond

nicocizik

Hi Redmond,

This is not a known issue with ReportBuilder. What type of application are
you creating? Which database/connection are you currently using to access
your data? Which versions of Delphi/ReportBuilder are you using? Once your
application is compiled, does the application run at a reasonable speed?
How many tables are in the database you are accessing?

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com

rbuser

Hi,

- Win32 application
- Interbase SQL
- Deplhi version 7. RB version 9.02
- Yes
- About 170 tables. Why would this matter? As you see in the code, I only
access 3 tables.

Thanks
Redmond

nicocizik

Hi Redmond,

When performing a simple table view in DADE, all ReportBuilder is doing is
retreiving the table schema from the database. This is a simple function
and should not take much time. As a test try copying the SQL code you gave
before into an ordinary Interbase Query object and see how fast it is able
to execute.

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com

rbuser

Hi,

Its just as slow in executing.
So I guess the problem's in how the code (the tables) are built)?
Its just that this architechture is the only one that worked for me...

Thanks
Red

rbuser

In article ,
redmond.shannon@sasims.com says...

If it is a SQL issue, you might have better luck posting to
borland.public.interbase.general or
borland.public.interbase.sql

EdB