slow in select * from table in sqlserver

Question

0.00/5 (No votes)

See more:

hi I have a static IP for SQL Server 2008 to connect to the database server, but I
When the my project (Delphi) and the component (sdac) 30000 record in Table I open(select * from table) the database record about 1 minute for me to return ; Open the database table speed is very low.

How and in what way can I fix this problem
The best way to do this type of query to the database and
odbc or oledb connec?
and connection string why is?
Please answer me that!
Thank you very much!
my email is : [DELETED]@yahoo.com
thanks

[edit]Email removed - OriginalGriff[/edit]

Posted 7-Sep-13 22:43pm

Member 10259800

Updated 8-Sep-13 1:10am

phil.o

v3

Add a Solution

Comments

OriginalGriff 8-Sep-13 5:49am

Never post your email address in any forum, unless you really like spam! If anyone replies to you, you will receive an email to let you know

phil.o 8-Sep-13 6:55am

How much columns are there in your table? Maybe you can restrict your query to specific ones instead of '*'.
And, if there are 30000 rows in the table, it's not surprising this takes a certain amount of time to load.
Are you sure you need to load each and every record? Could you restrict it to a most relevant subset of data?

André Kraak 8-Sep-13 6:57am

Try specifying the columns you need, instead off using '*'. Minimize the amount of information that needs to be transfered over the connection.
The same goes for filtering the result. If you do any filtering in your code, move this to a WHERE clause in your query to again minimize the amount of information.

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

thatraja · Answer 1 · 2013-09-09T23:46:00

Solution 2

SQL SERVER – 15 Best Practices for Better Database Performance[^]
OLE DB or ODBC?[^]

Posted 9-Sep-13 23:46pm

thatraja

slow in select * from table in sqlserver

1 solution

Solution 2

Add your solution here

Preview 0

slow in select * from table in sqlserver

1 solution

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us