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

C#

 
AnswerRe: To Throw or Not To Throw Pin
V.21-May-13 23:38
professionalV.21-May-13 23:38 
GeneralRe: To Throw or Not To Throw Pin
Eddy Vluggen22-May-13 0:30
professionalEddy Vluggen22-May-13 0:30 
GeneralRe: To Throw or Not To Throw Pin
V.22-May-13 0:38
professionalV.22-May-13 0:38 
GeneralRe: To Throw or Not To Throw Pin
Eddy Vluggen22-May-13 6:55
professionalEddy Vluggen22-May-13 6:55 
GeneralRe: To Throw or Not To Throw Pin
jschell22-May-13 8:25
jschell22-May-13 8:25 
AnswerRe: To Throw or Not To Throw Pin
jschell22-May-13 8:47
jschell22-May-13 8:47 
QuestionFaster way of filling a Dataset Pin
MumbleB21-May-13 8:17
MumbleB21-May-13 8:17 
AnswerRe: Faster way of filling a Dataset Pin
Jasmine250121-May-13 9:29
Jasmine250121-May-13 9:29 
Sounds like you are retrieving a huge dataset and doing calculations in your client code? If these statistics or calculations can be done on the SQL server, it will likely increase performance (because sql servers are really good at aggregating stats) and it will decrease network load, which I suspect is your problem in the first place. Getting 1.4 million rows from the database will always take a long time because it has to transfer all that data over the network. If you only had one boolean column in your table, 1.4 million rows would be 1.3MB of data - your 20 columns could result in your "fill the dataset" being a 20MB download, and that's never gonna be real fast.

To recap - solutions involve reducing the amount of data you need to transfer. Ideally, only transfer exactly what needs to be seen by the user and nothing more. Even if your query is super fast, transferring data over the network isn't. Your index on the date column is about all you can do to speed up the query since it's your only selection criteria, but again, finding the data isn't probably the issue.
AnswerRe: Faster way of filling a Dataset Pin
SledgeHammer0121-May-13 11:30
SledgeHammer0121-May-13 11:30 
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 
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 

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.