Direct access to MSDE tables without providers

Direct access to MSDE tables without providers

• NickReiser

  The SQLClient is the prefered and the fastest one. Perhaps there is a problem within your configuration in your msde.

  
  HTH, Jens Suessmeyer.

  
  

• Brian Welcker - MS

  You need a data access provider for accessing the database.

  HTH, Jens Suessmeyer.

  
  

• German Masis

  There is no switch for bringing sql server to lightning speed (although SQL Server is very fast coming out-of-the-box), its more a less a combination of designing the database you code the infrastructure and the indexes.
  
  Look at http://www.sql-server-performance.com/ for more information, this is a good starting point.
  
  
  HTH, jens Suessmeyer.
  
  

• edwardbeck

  Hi,

  Can you tell me what is preferred configuration for using queries on 1 million of records

  Thank's
  Alexei

  
  
  

• heppiedad

  Hi,

  I am coding in c# with oledb to access to MSDE. I have also tryed to use SQLClient. But it still littly slow. Where can I get another one

  Thank's
  Alexei

  
  
  
• Direct access to MSDE tables without providers