Click here to Skip to main content
12,950,268 members (65,340 online)
Rate this:
 
Please Sign up or sign in to vote.
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
Updated 8-Sep-13 1:10am
phil.o89K
v3
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

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

    Print Answers RSS
Top Experts
Last 24hrsThis month
OriginalGriff 5,829
CHill60 3,460
Maciej Los 2,953
Jochen Arndt 1,975
ppolymorphe 1,820


Advertise | Privacy | Mobile
Web01 | 2.8.170525.1 | Last Updated 10 Sep 2013
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100