Click here to Skip to main content
14,544,060 members

.NET Framework

 
GeneralRe: Best practice connecting to database Pin
A_Griffin6-Aug-17 5:10
MemberA_Griffin6-Aug-17 5:10 
GeneralRe: Best practice connecting to database Pin
Eddy Vluggen6-Aug-17 5:19
professionalEddy Vluggen6-Aug-17 5:19 
AnswerRe: Best practice connecting to database Pin
Gerry Schmitz6-Aug-17 4:16
mveGerry Schmitz6-Aug-17 4:16 
GeneralRe: Best practice connecting to database Pin
Eddy Vluggen6-Aug-17 4:44
professionalEddy Vluggen6-Aug-17 4:44 
GeneralRe: Best practice connecting to database Pin
A_Griffin6-Aug-17 4:48
MemberA_Griffin6-Aug-17 4:48 
GeneralRe: Best practice connecting to database Pin
Eddy Vluggen6-Aug-17 5:08
professionalEddy Vluggen6-Aug-17 5:08 
GeneralRe: Best practice connecting to database Pin
A_Griffin6-Aug-17 5:18
MemberA_Griffin6-Aug-17 5:18 
GeneralRe: Best practice connecting to database Pin
Eddy Vluggen6-Aug-17 5:36
professionalEddy Vluggen6-Aug-17 5:36 
A_Griffin wrote:
but the other half of my gut (!) feels uneasy about opening and closing a hundred or so connections in such quick succession...
After implementing a scenario where that actually happened, I'm not.

A Dokan-drive is something that shows up and acts like a drive in Windows Explorer (including any save-dialog), with the implementation of fetching the data left to the programmer. Clicking on a folder in Windows Explorer would launch a whole lotta operations - it would first want to know if there is such a file or folder, then a request to get its contents, then a request for each file in there, so it could display a size and icon. And the virusscanner requesting those files too, since they were being accessed.

Each operation, in VB.NET, would open and close a connection on my local machine, with a local database-server. The speed was limited by the capabilities of the Dokan-driver, not the speed of the database or opening/closing connections.

A_Griffin wrote:
I don't expect a huge (or even noticeable) difference in performance with the size of databases I'm working with at the moment.
..then fill a table with 2 million records. Generate some nonsense-data in a loop and give it a try.

If your boss asks why you choose one or the other, it is better to present an experiment than to point to some idiot on the internet Smile | :)
Bastard Programmer from Hell Suspicious | :suss:
If you can't read my code, try converting it here[^]

GeneralRe: Best practice connecting to database Pin
Gerry Schmitz9-Aug-17 7:31
mveGerry Schmitz9-Aug-17 7:31 
GeneralRe: Best practice connecting to database Pin
Eddy Vluggen9-Aug-17 8:25
professionalEddy Vluggen9-Aug-17 8:25 
QuestionHow to get each items "valuemember" value of checkedlistbox using for loop and show it in messagebox in winform Pin
bhagyashri from kolhapur19-Jul-17 2:33
Memberbhagyashri from kolhapur19-Jul-17 2:33 
AnswerRe: How to get each items "valuemember" value of checkedlistbox using for loop and show it in messagebox in winform Pin
Richard MacCutchan19-Jul-17 4:56
mveRichard MacCutchan19-Jul-17 4:56 
QuestionOne Wier library for VB.NET Pin
Member 1218072911-Jul-17 23:47
MemberMember 1218072911-Jul-17 23:47 
AnswerRe: One Wier library for VB.NET Pin
Afzaal Ahmad Zeeshan12-Jul-17 0:30
mvaAfzaal Ahmad Zeeshan12-Jul-17 0:30 
GeneralRe: One Wier library for VB.NET Pin
Member 1218072920-Jul-17 6:01
MemberMember 1218072920-Jul-17 6:01 
QuestionMVC: ValidationSummary("); dosn't work with Partial Viwe Pin
Azza ALbelushi5-Jul-17 23:55
MemberAzza ALbelushi5-Jul-17 23:55 
AnswerRe: MVC: ValidationSummary("); dosn't work with Partial Viwe Pin
Richard Deeming6-Jul-17 1:22
mveRichard Deeming6-Jul-17 1:22 
GeneralRe: MVC: ValidationSummary("); dosn't work with Partial Viwe Pin
Azza ALbelushi6-Jul-17 2:49
MemberAzza ALbelushi6-Jul-17 2:49 
GeneralRe: MVC: ValidationSummary("); dosn't work with Partial Viwe Pin
Richard Deeming6-Jul-17 2:52
mveRichard Deeming6-Jul-17 2:52 
GeneralRe: MVC: ValidationSummary("); dosn't work with Partial Viwe Pin
Azza ALbelushi6-Jul-17 8:00
MemberAzza ALbelushi6-Jul-17 8:00 
GeneralRe: MVC: ValidationSummary("); dosn't work with Partial Viwe Pin
Richard Deeming6-Jul-17 9:07
mveRichard Deeming6-Jul-17 9:07 
GeneralRe: MVC: ValidationSummary("); dosn't work with Partial Viwe Pin
Azza ALbelushi6-Jul-17 19:07
MemberAzza ALbelushi6-Jul-17 19:07 
GeneralRe: MVC: ValidationSummary("); dosn't work with Partial Viwe Pin
Richard Deeming7-Jul-17 0:29
mveRichard Deeming7-Jul-17 0:29 
GeneralRe: MVC: ValidationSummary("); dosn't work with Partial Viwe Pin
Azza ALbelushi10-Jul-17 20:05
MemberAzza ALbelushi10-Jul-17 20:05 
GeneralRe: MVC: ValidationSummary("); dosn't work with Partial Viwe Pin
Richard Deeming11-Jul-17 1:29
mveRichard Deeming11-Jul-17 1:29 

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.