Re: MSDE Performance and Reliability

Johnnie Norsworthy wrote:

"Hannes Danzl[NDD]" <hannes@xxxxxxxxxxxxxxxxxxx> wrote in message
news:xn0f7fteboin7o00a@xxxxxxxxxxxxxxxxxxxxxxxxx
Johnnie Norsworthy wrote:

How does MSDE or SQL Server Express or whatever it is called now compare
to other Delphi databases? I can't seem to find any statistics or
comments on it.

You're not allowed to post any performance tests about SQL Server or
Oracle or most other big databases ...

How about these direct questions posted to the group about MSDE:

Is it fast enough?

SQL Server Express is very fast.

Does it crash with damaged files?

Depending on the level of corruption, it either recognizes it and reports
errors, crashes or simply refuses to start at all.

If so, are they repairable?

There are thirdparty tools, the only one i ever used was OnTrack SQL Server
Recovery, which did the job in the case we needed it (due to non existing
backups).

Would you use it?

I would only use it if the product is designed for the full blown SQL server
and the SQLExpress solution is only a downsized version. If your application
is a shrinkwrap product or a doesn't need the might of a full blown SQL
Server, there are better solutions for Delphi available, that are not only
easier to maintain but in all likelyhood also perform better if used in the
way they are developed fo

Is there an example using it with Delphi I can try to judge details myself,
possibly using the Northwind DB?

The access method from Delphi is ADO, as such there are surely demos out
there. I've never looked for them though.

--

Hannes Danzl [NexusDB Developer]
Newsgroup archive at http://www.tamaracka.com/search.htm
.

Relevant Pages

  • Delphi 2006 and SQL Server
    ... Congratulations to all the guys at Borland. ... Delphi 2006 is a great ... The application that I have developed is a Delphi VCL Win32 ... there has not been enough emphasis at Borland to support SQL Server. ...
    (borland.public.delphi.non-technical)
  • Re: SQL Server Mobile Edition & C#
    ... Sorry but I am not familiar enough with Delphi 6 to answer. ... >> .Net Compact Framework MVP ... >>>>> and modify SQL Server Mobile databases using the SQL server GUI. ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: D2006 hits the UK
    ... Jim Cooper wrote: ... > in exactly the same way you once upon a time decided to use Delphi. ... Someone else mentioned SQL Server 2005. ... Borland Certified Advanced Delphi 7 Developer ...
    (borland.public.delphi.non-technical)
  • Re: MS SQL Server Database Support in Delphi Professional
    ... > release the MS SQL Server driver for dbExpress in Delphi 7 Pro. ... It is possible to write cross platform apps with that thing? ...
    (borland.public.delphi.non-technical)
  • Re: So, anyone asked about Win64 at Borcon?
    ... Over the past week of BorCon sessions and meetings and hallway ... about Delphi support for Compact Frameworks. ... of the Microsoft SQL Server 2005 team. ... Delphi Compiler Core: http://homepages.borland.com/dthorpe/blog/delphi/ ...
    (borland.public.delphi.non-technical)