We do a simple select 1 million record over a client server setup with SQL server 2008 and it take 10 times more time to get the results that doing the same request with Microsoft access db.
Exactly the same setup for the network. Any special setup in SQL server we are missing.
thank you for your help
sql server, java,
April 4, 2011 5:46 PM
April 5, 2011 6:39 PM