Click here to Skip to main content
15,499,155 members
Home / Discussions / Database
   

Database

 
Questionsave documents in/out MySQL Pin
Jassim Rahma25-Jun-14 20:30
MemberJassim Rahma25-Jun-14 20:30 
AnswerRe: save documents in/out MySQL Pin
Jörgen Andersson25-Jun-14 21:09
professionalJörgen Andersson25-Jun-14 21:09 
QuestionSql Query for StoreProcedure to generate reports and subreports Pin
Member 1074488725-Jun-14 17:52
MemberMember 1074488725-Jun-14 17:52 
AnswerRe: Sql Query for StoreProcedure to generate reports and subreports Pin
Jörgen Andersson25-Jun-14 21:11
professionalJörgen Andersson25-Jun-14 21:11 
Question[Bug][java.sql.DriverManager.getConnection(Unknown Source)] Pin
Thong LeTrung25-Jun-14 6:40
MemberThong LeTrung25-Jun-14 6:40 
QuestionPerformance problem Pin
sma123#23-Jun-14 8:25
Membersma123#23-Jun-14 8:25 
AnswerRe: Performance problem Pin
Eddy Vluggen23-Jun-14 8:38
professionalEddy Vluggen23-Jun-14 8:38 
AnswerRe: Performance problem Pin
David Mujica23-Jun-14 9:35
MemberDavid Mujica23-Jun-14 9:35 
I agree with Eddy, this is not a performance problem, seems more like a poor implementation of user requirements.

Am I correct in understanding that the report fetches 55 million records, but does it display that much data ?

Displaying 55 detail records per page would generate a 1 million page report. Really ? Does the user need to see all of that data ?

Is there any way to create summary data at an off-peak time so the report can generate from that summary data ?

What about implementing an asynchronous report generator where the user selects the input parameters, then "kicks off" the report in the background. The report could generate an HTML or PDF report, then send an email to the requestor with a hyperlink to the report when it is complete.

You would be surprised how agreeable a user would be to a solution like this. They kick off a report, then they can move on to something else while it generates. The email tells them when it is done.

Hope these ideas help. Smile | :)
GeneralRe: Performance problem Pin
jschell25-Jun-14 13:22
Memberjschell25-Jun-14 13:22 
GeneralRe: Performance problem Pin
Eddy Vluggen26-Jun-14 1:25
professionalEddy Vluggen26-Jun-14 1:25 
AnswerRe: Performance problem Pin
Mycroft Holmes25-Jun-14 1:31
professionalMycroft Holmes25-Jun-14 1:31 
QuestionA small naming problem Pin
Jörgen Andersson22-Jun-14 23:23
professionalJörgen Andersson22-Jun-14 23:23 
AnswerRe: A small naming problem Pin
Kornfeld Eliyahu Peter22-Jun-14 23:42
professionalKornfeld Eliyahu Peter22-Jun-14 23:42 
GeneralRe: A small naming problem Pin
Jörgen Andersson22-Jun-14 23:49
professionalJörgen Andersson22-Jun-14 23:49 
AnswerRe: A small naming problem Pin
Kornfeld Eliyahu Peter23-Jun-14 0:00
professionalKornfeld Eliyahu Peter23-Jun-14 0:00 
GeneralRe: A small naming problem Pin
Jörgen Andersson23-Jun-14 0:34
professionalJörgen Andersson23-Jun-14 0:34 
AnswerRe: A small naming problem Pin
Shameel30-Jun-14 5:28
professionalShameel30-Jun-14 5:28 
QuestionHow to connect with SSH Tunnel? Pin
Jassim Rahma22-Jun-14 22:30
MemberJassim Rahma22-Jun-14 22:30 
AnswerRe: How to connect with SSH Tunnel? Pin
Simon_Whale22-Jun-14 23:02
professionalSimon_Whale22-Jun-14 23:02 
GeneralRe: How to connect with SSH Tunnel? Pin
Jassim Rahma23-Jun-14 0:13
MemberJassim Rahma23-Jun-14 0:13 
QuestionRead Only Database Pin
Bastien Vandamme22-Jun-14 19:43
MemberBastien Vandamme22-Jun-14 19:43 
AnswerRe: Read Only Database Pin
Kornfeld Eliyahu Peter22-Jun-14 20:40
professionalKornfeld Eliyahu Peter22-Jun-14 20:40 
AnswerRe: Read Only Database Pin
Jörgen Andersson22-Jun-14 21:21
professionalJörgen Andersson22-Jun-14 21:21 
AnswerRe: Read Only Database Pin
Mycroft Holmes23-Jun-14 2:13
professionalMycroft Holmes23-Jun-14 2:13 
GeneralRe: Read Only Database Pin
Jörgen Andersson23-Jun-14 2:18
professionalJörgen Andersson23-Jun-14 2:18 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.