Click here to Skip to main content
15,868,016 members
Home / Discussions / Visual Basic
   

Visual Basic

 
QuestionFirst query to a local sql server run very slow , others almost instantly Pin
dilkonika21-Mar-14 4:38
dilkonika21-Mar-14 4:38 
AnswerRe: First query to a local sql server run very slow , others almost instantly Pin
Richard Deeming21-Mar-14 5:06
mveRichard Deeming21-Mar-14 5:06 
GeneralRe: First query to a local sql server run very slow , others almost instantly Pin
dilkonika21-Mar-14 5:41
dilkonika21-Mar-14 5:41 
AnswerRe: First query to a local sql server run very slow , others almost instantly Pin
Simon_Whale21-Mar-14 5:15
Simon_Whale21-Mar-14 5:15 
GeneralRe: First query to a local sql server run very slow , others almost instantly Pin
dilkonika21-Mar-14 5:38
dilkonika21-Mar-14 5:38 
GeneralRe: First query to a local sql server run very slow , others almost instantly Pin
Simon_Whale21-Mar-14 5:43
Simon_Whale21-Mar-14 5:43 
GeneralRe: First query to a local sql server run very slow , others almost instantly Pin
dilkonika21-Mar-14 8:34
dilkonika21-Mar-14 8:34 
AnswerRe: First query to a local sql server run very slow , others almost instantly Pin
Eddy Vluggen21-Mar-14 7:33
professionalEddy Vluggen21-Mar-14 7:33 
dilkonika wrote:
What can I do
Write a console app, and select where 1=1 from your database. Put that console-app in the startup-folder.

It may have multiple reasons; a database-server that isn't active yet, a database that's not yet loaded, the cache being empty, the enumerator waiting until it's enumerated..

I assume you're timing the query from a profiler?
Bastard Programmer from Hell Suspicious | :suss:
If you can't read my code, try converting it here[^]

GeneralRe: First query to a local sql server run very slow , others almost instantly Pin
dilkonika21-Mar-14 8:41
dilkonika21-Mar-14 8:41 
GeneralRe: First query to a local sql server run very slow , others almost instantly Pin
Dave Kreskowiak21-Mar-14 9:13
mveDave Kreskowiak21-Mar-14 9:13 
GeneralRe: First query to a local sql server run very slow , others almost instantly Pin
dilkonika21-Mar-14 9:37
dilkonika21-Mar-14 9:37 
GeneralRe: First query to a local sql server run very slow , others almost instantly Pin
Dave Kreskowiak21-Mar-14 9:51
mveDave Kreskowiak21-Mar-14 9:51 
GeneralRe: First query to a local sql server run very slow , others almost instantly Pin
dilkonika21-Mar-14 10:04
dilkonika21-Mar-14 10:04 
GeneralRe: First query to a local sql server run very slow , others almost instantly Pin
Dave Kreskowiak21-Mar-14 10:17
mveDave Kreskowiak21-Mar-14 10:17 
GeneralRe: First query to a local sql server run very slow , others almost instantly Pin
Eddy Vluggen21-Mar-14 11:16
professionalEddy Vluggen21-Mar-14 11:16 
QuestionUpdate cells in a DataGridView Pin
Felix Fosu17-Mar-14 9:10
Felix Fosu17-Mar-14 9:10 
SuggestionRe: Update cells in a DataGridView Pin
Eddy Vluggen18-Mar-14 9:38
professionalEddy Vluggen18-Mar-14 9:38 
QuestionSetting Priorities for Pre-Requisites Pin
SPSandy17-Mar-14 1:06
SPSandy17-Mar-14 1:06 
AnswerRe: Setting Priorities for Pre-Requisites Pin
Dave Kreskowiak17-Mar-14 3:24
mveDave Kreskowiak17-Mar-14 3:24 
QuestionRe: Setting Priorities for Pre-Requisites Pin
Eddy Vluggen18-Mar-14 9:31
professionalEddy Vluggen18-Mar-14 9:31 
AnswerRe: Setting Priorities for Pre-Requisites Pin
SPSandy19-Mar-14 7:19
SPSandy19-Mar-14 7:19 
GeneralRe: Setting Priorities for Pre-Requisites Pin
Eddy Vluggen20-Mar-14 21:43
professionalEddy Vluggen20-Mar-14 21:43 
GeneralRe: Setting Priorities for Pre-Requisites Pin
SPSandy21-Mar-14 7:03
SPSandy21-Mar-14 7:03 
GeneralRe: Setting Priorities for Pre-Requisites Pin
Eddy Vluggen21-Mar-14 7:37
professionalEddy Vluggen21-Mar-14 7:37 
GeneralRe: Setting Priorities for Pre-Requisites Pin
SPSandy21-Mar-14 7:47
SPSandy21-Mar-14 7:47 

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.