Click here to Skip to main content
14,331,937 members
   

Delphi

 
QuestionSQL Server 2005 Connection Strings.....Some Important Queries Pin
vijay.victory5-Mar-10 21:28
membervijay.victory5-Mar-10 21:28 
AnswerRe: SQL Server 2005 Connection Strings.....Some Important Queries Pin
Eddy Vluggen6-Mar-10 1:11
mveEddy Vluggen6-Mar-10 1:11 
QuestionSlow Performance of SQL Server 2005... Pin
vijay.victory3-Mar-10 2:51
membervijay.victory3-Mar-10 2:51 
AnswerRe: Slow Performance of SQL Server 2005... Pin
Stryder_13-Mar-10 4:36
memberStryder_13-Mar-10 4:36 
GeneralRe: Slow Performance of SQL Server 2005... Pin
vijay.victory4-Mar-10 17:25
membervijay.victory4-Mar-10 17:25 
AnswerRe: Slow Performance of SQL Server 2005... Pin
dan_fish3-Mar-10 5:12
memberdan_fish3-Mar-10 5:12 
GeneralRe: Slow Performance of SQL Server 2005... Pin
vijay.victory4-Mar-10 17:29
membervijay.victory4-Mar-10 17:29 
GeneralRe: Slow Performance of SQL Server 2005... Pin
dan_fish4-Mar-10 23:03
memberdan_fish4-Mar-10 23:03 
Hi Vijay

vijay.victory wrote:
some of my queries take time

then what should I do??


Identify where the queries are coming from in your code, then run them in Management Studio and take it from there. Right-clicking in the query pane and selecting 'Display Estimated Execution Plan' may be of help in identifying where your problem lies.

vijay.victory wrote:
Is it take more time than expected?

I can't tell you that - it's your database and code, so only you can know.

vijay.victory wrote:
all the queries having Select * will replaced with only needed Column name.

That's a good idea - you should always do that anyway because it reduces network traffic, but your problem here is the time of execution, not the time of retrieval.

Cheers,

Dan
QuestionDecrypt, validate and read large XML files Pin
abeaumont25-Feb-10 2:19
memberabeaumont25-Feb-10 2:19 
AnswerRe: Decrypt, validate and read large XML files Pin
dan_fish26-Feb-10 0:54
memberdan_fish26-Feb-10 0:54 
AnswerRe: Decrypt, validate and read large XML files Pin
nortee12-Dec-10 22:42
membernortee12-Dec-10 22:42 
QuestionNeed help compiling a project Pin
Member 386233915-Feb-10 8:43
memberMember 386233915-Feb-10 8:43 
AnswerRe: Need help compiling a project Pin
dan_fish19-Feb-10 5:00
memberdan_fish19-Feb-10 5:00 
AnswerRe: Need help compiling a project Pin
Corinna John23-Feb-10 0:20
memberCorinna John23-Feb-10 0:20 
GeneralRe: Need help compiling a project Pin
dan_fish25-Feb-10 0:54
memberdan_fish25-Feb-10 0:54 
GeneralRe: Need help compiling a project Pin
Member 386233925-Feb-10 10:53
memberMember 386233925-Feb-10 10:53 
GeneralRe: Need help compiling a project Pin
dan_fish26-Feb-10 0:41
memberdan_fish26-Feb-10 0:41 
GeneralRe: Need help compiling a project Pin
oginiza17-Mar-10 22:18
memberoginiza17-Mar-10 22:18 
QuestionImplementing an Indy HTTP Server object in an Activex library Pin
Sreenath Varma27-Jan-10 22:51
memberSreenath Varma27-Jan-10 22:51 
QuestionConvert Java Class to Delphi Pin
RajaSrirangan26-Jan-10 23:01
memberRajaSrirangan26-Jan-10 23:01 
AnswerRe: Convert Java Class to Delphi Pin
Corinna John2-Feb-10 1:02
memberCorinna John2-Feb-10 1:02 
Questionmultilanguage DLL or XML ( i18n) Internationalization Pin
Anouarzha1-Dec-09 23:33
memberAnouarzha1-Dec-09 23:33 
AnswerRe: multilanguage DLL or XML ( i18n) Internationalization Pin
Richard MacCutchan2-Dec-09 13:11
protectorRichard MacCutchan2-Dec-09 13:11 
AnswerRe: multilanguage DLL or XML ( i18n) Internationalization Pin
Gabriel.P.G3-Dec-09 5:54
memberGabriel.P.G3-Dec-09 5:54 
Questioncomputer name, motherboard sn, harddisk sn Pin
mazizi28-Nov-09 18:44
membermazizi28-Nov-09 18:44 

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.