Thanks, that's what I wanted to know...I think I'll pass on SQL 6.5,
because performance is an issue, and tech support might be. Since we
are planning on having several hundred users, Access really isn't a
long term option. I was primarily thinking about performance in terms
of 10-15 users, just as a stop gap measure until we get the full
version of SQL. We've ordered the 120-day eval of SQL 2000 Enterprise
though, and will purchase it when that expires, so in about 4 days the
Access/MSDE question won't be an issue anymore.
> The query optimizer in SQL Server 7.0 is vastly superior to the query
> optimizer in SQL Server 6.5, and the query optimizer in SQL Server 2000 is
> incrementally superior to the one in SQL Server 7.0.
> Additionally, there are features available in each of the later versions
> that are not available in the earlier versions.
> If performance is critical to you, then I would suggest SQL Server 2000. As
> an additional factor, you should expect that when Yukon (the internal
> Microsoft code name for the next version of SQL Server) is released in 2003,
> that Microsoft will stop supporting SQL Server 6.5.
> Re: performance of Access vs. MSDE (or SQL Server) ... make sure that you
> are comparing apples to apples. If you are benchmarking performance by
> timings with a single user, then Access will probably win. But if you need
> to support 100 concurrent users, then in all probability SQL Server will
> win. Remember that an enterprise level database such as SQL Server has
> additional overhead to avoid the database corruption that can happen with
> Access. Additional overhead reduces performance, but provides comfort that
> the application will be available with a greater level of reliability.
> BP Margolin
> Please reply only to the newsgroups.
> When posting, inclusion of SQL (CREATE TABLE ..., INSERT ..., etc.) which
> can be cut and pasted into Query Analyzer is appreciated.
> > Hello. Could someone tell me the differences between SQL 6.5 and SQL
> > 7.0 or SQL 2000? We have an opportunity to get what I believe is a
> > really good deal on SQL 6.5, but I'd like to know what I'm getting
> > first.
> > Thanks.
> > Ben Nelson
> > P.S. We're using MSDE right now, and I would appreciate any tips on
> > squeezing more performance out of it, because we either have to use it
> > or Access until we purchase SQL Server. I originally coded for
> > Access, but modified it to work with MSDE because I was told it
> > performed somewhat better than Access...now I'm not so sure. From a
> > performance perspective, should I restore the Access code from the
> > backup, or continue using the MSDE / SQL, Jr. code?