Go Back   Forum - BIRT Exchange > Spreadsheets in Java Forums > Designing e.Spreadsheet Reports
FAQ Search Today's Posts Mark Forums Read

Reply
 
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 11-28-2008, 03:14 PM
Junior Member
 
Join Date: Nov 2008
Posts: 1
Default Performance with e.spreadsheet

I try to developp report on a database with millions of lines. It seems that e.spreadsheet transfer all data from the database to my PC. I don't want to filter the data but just to count them. Do you know if there is a way to avoid this ? I use e.speadsheet on an IOB. Do you know if it's the same problem with a JDBC access to the database ?
Thanks for our answer.
Reply With Quote
  #2 (permalink)  
Old 12-15-2008, 12:15 PM
jtk jtk is online now
Junior Member
 
Join Date: Jun 2008
Posts: 21
Default For the JDBC datasource

You can always write a stored procedure/function that would just return the # of rows of your query. Therefore the data will not be transfered down. Then eSS can access this stored procedure/function instead.
Reply With Quote
Reply


Thread Tools
Display Modes




All times are GMT -7. The time now is 07:06 PM.


Content Relevant URLs by vBSEO 3.1.0