very slow template saving into db or file

rbuser

I am trying to save my template into db or file it takes very long time.
I know my dateset is very complext it takes 2 minutes, but I dont know what
happens when I save button on my design screen.
is that issue or normal behaviour. How can I optimize my templates
saving.

Any idea?

nicocizik

Hi Murat,

Which version of ReportBuilder are you using? Does saving to file take
about the same time it takes to save to your DB? Do your templates contain
numerous large objects such as ppImage or ppRichText components? If so,
this could be a reason that the saving time is slower due to the size of
these objects. Also, are you saving your templates in binary or ASCII
format?

--
Regards,

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

rbuser

Sorry about my late answer.
I am using version 10.04 Server edition.
I dont have any large object like images etc. except regular editbox. I
am sure about that my SQL procedure taking so long time. it taking about 2
minutes with my configuration. I am using my templates at MSSQL 2000 so when
I click save button in my report desing, it taking so long time. why do
this? I am just saving my template not running.
You can realize my issue with any report using with complex data.

PS: my dataset is only has about 100 rows. but calculation is taking
about 2 minutes.

Thanks

nicocizik

Hi Murat,

Does it take the same amount of time to save to file that it does to save to
your SQL Server database? Are you able to recreate this behavior using the
SQL Server demo located in the \RBuilder\Demos\.. directory?

--
Regards,

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

rbuser

You can test it easily
Open your demo from C:\Program Files\Borland\Delphi7\RBuilder\Demos\4.
EndUser Databases\SQL Server\2. ADO

Create any Report Template then use this sql code for DataSet
----------------------------
WAITFOR DELAY '00:01'
Select Test = 'Just for test'
----------------------------
Then Ok, you'll see it takes 1 minute, just save your template you will
see it take 1 minute.

Murat BUDAK