Click here to Skip to main content
15,922,419 members
Home / Discussions / C#
   

C#

 
GeneralRe: How memory is allocated in .Net application Pin
Tridip Bhattacharjee26-Feb-15 4:16
professionalTridip Bhattacharjee26-Feb-15 4:16 
GeneralRe: How memory is allocated in .Net application Pin
F-ES Sitecore26-Feb-15 4:42
professionalF-ES Sitecore26-Feb-15 4:42 
GeneralRe: How memory is allocated in .Net application Pin
Richard MacCutchan26-Feb-15 5:09
mveRichard MacCutchan26-Feb-15 5:09 
GeneralRe: How memory is allocated in .Net application Pin
Tridip Bhattacharjee26-Feb-15 21:03
professionalTridip Bhattacharjee26-Feb-15 21:03 
GeneralRe: How memory is allocated in .Net application Pin
Richard MacCutchan26-Feb-15 21:19
mveRichard MacCutchan26-Feb-15 21:19 
GeneralRe: How memory is allocated in .Net application Pin
Santosh K. Tripathi2-Mar-15 17:18
professionalSantosh K. Tripathi2-Mar-15 17:18 
GeneralRe: How memory is allocated in .Net application Pin
Richard MacCutchan26-Feb-15 22:30
mveRichard MacCutchan26-Feb-15 22:30 
QuestionRegarding Network buffer and datareader data fetch c# Pin
Tridip Bhattacharjee26-Feb-15 2:33
professionalTridip Bhattacharjee26-Feb-15 2:33 
i read many write up like how data reader fetch data. here are few links

http://stackoverflow.com/questions/1696128/sqldatareader-a-firehose-cursor-no-buffering?lq=1
http://stackoverflow.com/questions/23467482/how-does-sqldatareader-handle-really-large-queries?lq=1
http://stackoverflow.com/questions/1383920/how-datareader-works
http://stackoverflow.com/questions/22554158/how-much-data-can-be-stored-in-network-buffer-when-datareader-is-used

people are saying that data reader fetch data in chunk and store in network buffer and display from there. when all data read completed from buffer then again database round trip occur. that why people say data reader is efficient for data reading purpose because it minimize the db round trip but still many things are not clear to me

suppose i issue a sql query like Select empid,Name from employee table there are 10,000 rows then what will happen. how much data sql server will send to client?

suppose network buffer could store 8kb data then sql server may send more than 8kb data or sql server know the client pc network buffer size in advance?

suppose first 100 data is stored in network buffer so when again db trip will occur for next 100 data then same query will executed so how sql server will know that that time sql server has to send data from 101 to 200 etc?

i like to know the above internal process in details regarding interaction between sql server and data reader. so please share the know if some one knows it in details.

one bit different question. how we can determine each row size in byte or kb programmatically by c#. if possible give me direction with sample code. thanks
tbhattacharjee

GeneralRe: Regarding Network buffer and datareader data fetch c# Pin
PIEBALDconsult26-Feb-15 3:31
mvePIEBALDconsult26-Feb-15 3:31 
QuestionNeed help for auto response of a sms Pin
MA11026-Feb-15 2:03
MA11026-Feb-15 2:03 
AnswerRe: Need help for auto response of a sms Pin
Richard Andrew x6426-Feb-15 9:08
professionalRichard Andrew x6426-Feb-15 9:08 
QuestionNeed various algo asked during interview for dotnet C# Pin
Tridip Bhattacharjee26-Feb-15 0:19
professionalTridip Bhattacharjee26-Feb-15 0:19 
AnswerRe: Need various algo asked during interview for dotnet C# Pin
Pete O'Hanlon26-Feb-15 0:56
mvePete O'Hanlon26-Feb-15 0:56 
GeneralRe: Need various algo asked during interview for dotnet C# Pin
Tridip Bhattacharjee26-Feb-15 2:25
professionalTridip Bhattacharjee26-Feb-15 2:25 
GeneralRe: Need various algo asked during interview for dotnet C# Pin
Richard Givis24-Mar-15 11:03
Richard Givis24-Mar-15 11:03 
AnswerRe: Need various algo asked during interview for dotnet C# Pin
OriginalGriff26-Feb-15 0:57
mveOriginalGriff26-Feb-15 0:57 
GeneralRe: Need various algo asked during interview for dotnet C# Pin
Tridip Bhattacharjee26-Feb-15 2:25
professionalTridip Bhattacharjee26-Feb-15 2:25 
GeneralRe: Need various algo asked during interview for dotnet C# Pin
OriginalGriff26-Feb-15 2:37
mveOriginalGriff26-Feb-15 2:37 
GeneralRe: Need various algo asked during interview for dotnet C# Pin
jschell26-Feb-15 10:05
jschell26-Feb-15 10:05 
Questionprint the largest sum along with the sequence of numbers Pin
Member 1018671625-Feb-15 4:36
Member 1018671625-Feb-15 4:36 
SuggestionRe: print the largest sum along with the sequence of numbers Pin
Richard Deeming25-Feb-15 4:43
mveRichard Deeming25-Feb-15 4:43 
AnswerRe: print the largest sum along with the sequence of numbers Pin
Pete O'Hanlon25-Feb-15 6:00
mvePete O'Hanlon25-Feb-15 6:00 
GeneralRe: print the largest sum along with the sequence of numbers Pin
manchanx25-Feb-15 6:22
professionalmanchanx25-Feb-15 6:22 
SuggestionRe: print the largest sum along with the sequence of numbers Pin
Matt T Heffron25-Feb-15 7:55
professionalMatt T Heffron25-Feb-15 7:55 
GeneralRe: print the largest sum along with the sequence of numbers Pin
Pete O'Hanlon25-Feb-15 8:38
mvePete O'Hanlon25-Feb-15 8:38 

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.