Eclipse Community Forums: DTP » Performance with SQL Server and Birt

Help

Home

Home » Eclipse Projects » DTP » Performance with SQL Server and Birt

Show: Today's Messages :: Show Polls :: Message Navigator

Performance with SQL Server and Birt [message #523087]

Thu, 25 March 2010 00:54

Jorge M

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

thanks in advance, and sorry my poor english, I speak spanish Sad

[Updated on: Thu, 25 March 2010 00:56]

Report message to a moderator

Previous Topic:	Status of ODA driver for EMF/CDO and BIRT
Next Topic:	Performance with SQL Server and Birt

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Dec 03 20:24:41 GMT 2020

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter