Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I suppose to load all rows from SQLServer table, It's supposed to be ~5 Million Rows.
In the table there are 20 columns, and i need to pull 10 of them.
In a matter only of traffic, and overload on the system what is the efficient way to load:
Load* or load field1,Field2....
Thanks,
Jacob
With WHERE you reduce the number of rows(records) while using Load/Select Field1, Filed2 ....Field10 you reduce number of fields(attributes). Hope it helps.
I know it's reduce number of rows.. the question is about the DB is there a load difference between two approaches on his side..
It depends. Usually a where clause reduces processing time on a database. This can lead into faster query results if you have an index on the column..
Hi,
I would prefer you to use proper Index on the table to give you better performance.
Regards
ASHFAQ