Click here to Skip to main content
15,886,919 members
Home / Discussions / C#
   

C#

 
GeneralRe: Faster way of filling a Dataset Pin
Eddy Vluggen21-May-13 22:32
professionalEddy Vluggen21-May-13 22:32 
GeneralRe: Faster way of filling a Dataset Pin
SledgeHammer0122-May-13 4:48
SledgeHammer0122-May-13 4:48 
GeneralRe: Faster way of filling a Dataset Pin
Eddy Vluggen22-May-13 5:01
professionalEddy Vluggen22-May-13 5:01 
GeneralRe: Faster way of filling a Dataset Pin
SledgeHammer0122-May-13 6:54
SledgeHammer0122-May-13 6:54 
GeneralRe: Faster way of filling a Dataset Pin
Eddy Vluggen22-May-13 7:15
professionalEddy Vluggen22-May-13 7:15 
GeneralRe: Faster way of filling a Dataset Pin
MumbleB31-May-13 6:46
MumbleB31-May-13 6:46 
AnswerRe: Faster way of filling a Dataset Pin
Pete O'Hanlon21-May-13 23:06
mvePete O'Hanlon21-May-13 23:06 
GeneralRe: Faster way of filling a Dataset Pin
MumbleB31-May-13 6:40
MumbleB31-May-13 6:40 
Thanks Pete and all the other guys. I need all the data to generate a report, summary billing report. SO client-side calculations etc is a must. What I have found helpful was creating a stored procedure on the DB, it is a local DB not a network DB. Concept phase before business would through money at a server. Did a heck of a lot of reading up on PostGres as this is my DB. For now I am sitting at 2 million records and it runs fine. Takes about 2 minutes to collect and do all relevant calculations etc. Indexing the date column helped with performance as well as I use this to create the report for a specific date range. Just for interest sake, 2 million records is only one months worth of data, which is what I am extracting from an Oracle Database which carries way more data than what I am carrying to do the billing. So, in short, it works for now. Will see as the local DB grows how the performance degrades.
Excellence is doing ordinary things extraordinarily well.

QuestionValidate textbox (characters) Pin
Member 991209121-May-13 7:55
Member 991209121-May-13 7:55 
AnswerRe: Validate textbox (characters) Pin
Richard MacCutchan21-May-13 21:10
mveRichard MacCutchan21-May-13 21:10 
QuestionTrick to Access derived class method from base Pin
dinesh.17krishnan21-May-13 1:42
dinesh.17krishnan21-May-13 1:42 
AnswerRe: Trick to Access derived class method from base Pin
OriginalGriff21-May-13 1:57
mveOriginalGriff21-May-13 1:57 
AnswerRe: Trick to Access derived class method from base Pin
Keith Barrow21-May-13 3:59
professionalKeith Barrow21-May-13 3:59 
AnswerRe: Trick to Access derived class method from base Pin
Keld Ølykke21-May-13 5:36
Keld Ølykke21-May-13 5:36 
AnswerRe: Trick to Access derived class method from base Pin
Dave Kreskowiak21-May-13 6:05
mveDave Kreskowiak21-May-13 6:05 
AnswerRe: Trick to Access derived class method from base Pin
Bernhard Hiller21-May-13 20:48
Bernhard Hiller21-May-13 20:48 
AnswerRe: Trick to Access derived class method from base Pin
dinesh.17krishnan21-May-13 22:12
dinesh.17krishnan21-May-13 22:12 
GeneralRe: Trick to Access derived class method from base Pin
Keld Ølykke22-May-13 19:35
Keld Ølykke22-May-13 19:35 
AnswerRe: Trick to Access derived class method from base Pin
Ravi Bhavnani22-May-13 4:59
professionalRavi Bhavnani22-May-13 4:59 
Questionhow to save voice from modem as a wav file whic can be accessed by speech sdk for processing Pin
samweps21-May-13 1:16
samweps21-May-13 1:16 
AnswerRe: how to save voice from modem as a wav file whic can be accessed by speech sdk for processing Pin
Richard MacCutchan21-May-13 2:55
mveRichard MacCutchan21-May-13 2:55 
QuestionAnother tcp / net question.. Pin
Member 986287220-May-13 23:49
Member 986287220-May-13 23:49 
AnswerRe: Another tcp / net question.. Pin
Eddy Vluggen21-May-13 3:02
professionalEddy Vluggen21-May-13 3:02 
QuestionGenerics in C# Pin
srikumarrampa20-May-13 23:37
srikumarrampa20-May-13 23:37 
AnswerRe: Generics in C# Pin
Abhinav S21-May-13 1:08
Abhinav S21-May-13 1:08 

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.