September 2, 2010 at 11:02 am
Hi Folks,
Can any one point out any direction for me on what can I do to read data as soon as possible? I am using .NET. I have some external indexing task to perform, which may require me to read all existing data from all tables on designated database/server.
Thanks.
September 2, 2010 at 11:57 am
I am not sure what you mean by as soon as possible? can you give us a scenario of what you are tying to accomplish and where the hang up is?
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
September 2, 2010 at 12:44 pm
I am sorry I used the wrong word but I don't know (can't) how to modify the post's title:
It should be how to read records as fast as possible.
My indexer program needs to read records from designated source, I want it working as fast as possible.
For example, if there 100000 rows in a table, I need to read them all and parse them. I know for importing data there is a bulk insert, just not sure if there is any similar one for reading out.
I am not using the full text index here. This is a totally different approach in terms of indexing.
I hope this is clearer and thanks for your reply.
September 2, 2010 at 12:49 pm
There is nothing like a bulk read in SQL.
The ability to get the records out of a database as fast as possible depends intelegent design.
The database needs to be structured properly for performance with indexes and normalized data structures. the Query also needs to be written to optimize performance.
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
September 2, 2010 at 1:04 pm
I see, so basically there is nothing I can do.
Thanks anyway.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply