Click here to Skip to main content
11,493,391 members (73,201 online)
Rate this: bad
good
Please Sign up or sign in to vote.
See more: Embedded
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 23:43pm
Edited 8-Sep-13 2:10am
phil.o45.7K
v3
Comments
OriginalGriff at 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 at 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 at 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
0 Sergey Alexandrovich Kryukov 408
1 F-ES Sitecore 244
2 Maciej Los 241
3 CPallini 233
4 Nakul Chaudhari 225
0 Sergey Alexandrovich Kryukov 10,237
1 OriginalGriff 8,730
2 Sascha Lefèvre 3,664
3 Maciej Los 3,392
4 Richard Deeming 2,500


Advertise | Privacy | Mobile
Web01 | 2.8.150520.1 | Last Updated 10 Sep 2013
Copyright © CodeProject, 1999-2015
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