main logo
Subject: RE: sql SERVER EXPRESSS
Author: "Stephen the Cook"
Posted: 2005/06/30 12:35:45
 
View Entire Thread
New Search


Michael Hawksworth <> wrote this on Thursday, June 30, 2005 9:05 AM:

> The drawback as I see it is that it still needs installing on a
> system.
>
> The ability to xcopy a database is much better but it still adds a
> level
> of complexity to the projects. And small businesses don't like
> complexity.

Only downside is patches that need to be applied. Setting up your installer
to install the server isn't that tough, I mean if your deploying a com, or
crystal reports is much the same thing. Just hook in the MSI and it works.
You also pass in the backup file for your system. Then attach that file or
restore from it in YOUR CODE as your app starts.

> I haven't tested it to death yet but on decent kit I don't get any
> better performance than I would from native tables sat on a win2K
> server
> for the type of app I think it would work for.

Having a 4 table or more join is where this server shines. Having + million
row tables it also helps.

Stephen Russell
S.R. & Associates
Memphis, TN 38115

901.246-0159

http://spaces.msn.com/members/srussell/




 
©2005 Stephen the Cook
<-- Prior Message New Search Next Message -->