Skip to main content

Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » DTP » Performance with SQL Server and Birt
Performance with SQL Server and Birt [message #597394] Thu, 25 March 2010 00:54
Jorge M is currently offline Jorge MFriend
Messages: 2
Registered: March 2010
Junior Member
Hi, I am new with birt, and I am having some troubles

The worst is with performance I have a sp as it

Declare @table table (Field ... type, Field .. type)
Insert into @table
Select field, field, field from TableReal where
Some filters....

This returns 4000 rows from sql server 2000 in 20 segs, but running it from Birt Preview in eclipse turns into 17mins :S

I have no lock into my SP, Set NOCount On

Sql server 2000, Java 1.6, Eclipse 3.4.2, Birt 2.3.2.r232 and jdbc 2.0 latest from microsoft ( i can't see build number)

When I use Table variables and multiples inserts in My SP Birts run slow my reports :S and I don't know what I need to do :S
Previous Topic:Performance with SQL Server and Birt
Next Topic:Generic parser API
Goto Forum:

Current Time: Fri May 14 08:39:44 GMT 2021

Powered by FUDForum. Page generated in 0.01676 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top