Which is faster Access or SQL Server 2000?

Which is faster Access or SQL Server 2000? (Full Version)

All Forums >> [Web Development] >> ASP, PHP, and Database

Message

Guest -> Which is faster Access or SQL Server 2000? (9/27/2001 20:15:00)
Which is faster Access or SQL Server 2000? I don't expect many users on my site. Which is the better choice for grabbing records from a database with over 100,000 rows. Thanks, Skippy

Stuey -> RE: Which is faster Access or SQL Server 2000? (9/27/2001 20:50:00)
I would suggest "try both" however the I think the speed restriction is not going to be the database. If this is simple Select * from table without any criteria I would go for a static page. ( SQL and Access will produce these for you) ------------------ Stuart Steele stuart@stuweb.co.uk http://www.stuweb.co.uk

Spooky -> RE: Which is faster Access or SQL Server 2000? (9/27/2001 16:36:00)
Access will handle it, the main concern is the number of users. If its very small, and cost or administration is a problem, then by all means use Access. If you are perfoming lots of complex queries many times per page, and have a lot of users, go for SQL ------------------ §þððk¥ "I am Spooky of Borg. Prepare to be assimilated, babycakes!" Subscribe to OutFront News Database / DRW Q & A The Spooky Login! VP-ASP Shopping cart

Page: [1]

Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI

0.09375