Baanboard.com

Go Back   Baanboard.com > Forum > Baan Quick Support: Functional & Technical > Miscellaneous

User login

Frontpage Sponsor

Main

Google search


Poll
How big is your Baan-DB (just Data AND Indexes)
0 - 200 GB
15%
200 - 500 GB
27%
500 - 800 GB
3%
800 - 1200 GB
9%
1200 - 1500 GB
12%
1500 - 2000 GB
12%
> 2000 GB
21%
Total votes: 33

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 25th October 2018, 15:01
raviteja.m123@g raviteja.m123@g is offline
Newbie
 
Join Date: Jul 2015
Posts: 1
raviteja.m123@g is on a distinguished road
Baan: LN10.4 - DB: SQL - OS: WINDOWS
Taking time for sending Data to IR reporting

Hi,

I am trying to print a IR Excel report for an LN session, where the number of record are more than 7 lakhs. It is taking more than 5 hours .Is there any way I can optimize it . Also if the number of records exceeds the excel max limit(1048576),what happens to the report.

I am using LN 10.5
Reply With Quote
  #2  
Old 29th October 2018, 13:22
mark_h's Avatar
mark_h mark_h is offline
Guru
 
Join Date: Sep 2001
Location: Kentucky, USA
Posts: 7,141
mark_h will become famous soon enough
Baan: Baan 4C4 A&D1 - DB: Oracle - OS: Sun Solaris
Well can't answer the first part - but the one time I screwed up and ran a report with more than the excel limit - the file was truncated, but I seem to recall some warnings from excel.
__________________
Mark

GO Cards!
My latest mantra - make sure you have latest stpapi patches and the latest session object. If on LN then please explore the option of using DAL2 functionality.

Shared Solutions for Baan systems provided free by Baan Board.
Play the Google game and help Baanboard get better rankings. Do your part. Click here to find how.
Reply With Quote
  #3  
Old 12th November 2018, 03:39
shah_bs's Avatar
shah_bs shah_bs is offline
Guru
 
Join Date: Jan 2002
Location: Lewisville, Texas
Posts: 390
shah_bs is on a distinguished road
Baan: BAAN IVc3 with A&D2.2b - DB: ORACLE 9 - OS: HPUX
Why it takes time cannot be assessed without knowing the details of your SELECT logic. Maybe there are SELECTs that do not appropriately use indexes. Maybe if you analyze the program in debug to find which select is taking the longest, that will point to some solution.

As to the limits of EXCEL, you have to program around that by creating a new file after say every half-million records are written - with file name ending in a sequence like 001, 002, 003 etc. We leave some room for doing further manipulations in EXCEL by limiting to half-million - even that is too big for a spreadsheet to process fast later on.
Reply With Quote
Sponsored Links
  #4  
Old 13th November 2018, 10:55
Ajesh's Avatar
Ajesh Ajesh is offline
Guru
 
Join Date: Feb 2009
Posts: 534
Ajesh is on a distinguished road
Baan: LN 10.4 - DB: Oracle - OS: HP-Unix
Nested Queries, Multiple Table Fields selection are killers.
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Default time is different from System Time bumbaermail Tools Administration & Installation 1 10th May 2011 10:26
Problem creating data source in ERP LN reporting studio free_2tak Tools Development 3 11th February 2011 11:38
CODE: Validate Import Exchange Scheme Data gfasbender Code & Utilities 10 18th November 2009 00:19
Taking too much time too execute brp.close() teddybear Tools Development 5 15th September 2009 18:37
Analytical Reporting Repository for BAAN (ERP) - Intro $5,000 Doug Razzano General Discussion & Chat 1 9th May 2002 22:20


All times are GMT +2. The time now is 11:41.


©2001-2018 - Baanboard.com - Baanforums.com