Re: Speed of MSDE over Access
From: User (User_at_aol.com)
Date: 07/23/04
- Next message: PVR: "CHECKSUM >>> How to know on which columns the checksum got created"
- Previous message: Mike Perry: "Re: Insert, Delete, and Update - best practices advice please"
- In reply to: Andrew J. Kelly: "Re: Speed of MSDE over Access"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 23 Jul 2004 16:39:22 -0700
The only uncontested selling point for MSDE in this case is transaction
logging/non-database corruption.
"Andrew J. Kelly" <sqlmvpnooospam@shadhawk.com> wrote in message
news:#CT6BxMcEHA.3904@TK2MSFTNGP12.phx.gbl...
> Faster is totally dependant on what you are doing. SQL Server is not
> necessarily faster than Access but that is not the point either. They are
> two completely different databases. SQL Server is much more robust and
with
> that comes more overhead. When your talking small data sets Access with
> most likely beat SQL Server in some areas of speed but if your talking
> millions of rows that can be another story. If your reason to switch to
SQL
> Server is strictly for speed your making the wrong choice.
>
> --
> Andrew J. Kelly SQL MVP
>
>
> "Beeeeeeeeeeeeves" <Beeeeeeeeeeeeves@discussions.microsoft.com> wrote in
> message news:0AAE847C-5748-41AA-AEEB-FF8C8AB8FD60@microsoft.com...
> > yo
> >
> > can anyone think of a good test that will prove msde is faster than
> access? our company is thinking of rolling it out onto the field's laptops
> which would be great for me as a developer, but they want us to prove it's
> faster and thus better from the user's perspective before they go to the
> effort of recalling 60-odd laptops in.
> >
> > But we want them to, what will be a good test that will convince them?
> >
>
>
- Next message: PVR: "CHECKSUM >>> How to know on which columns the checksum got created"
- Previous message: Mike Perry: "Re: Insert, Delete, and Update - best practices advice please"
- In reply to: Andrew J. Kelly: "Re: Speed of MSDE over Access"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
