Best SQL Server? 
Author Message
 Best SQL Server?

I'm looking to start a war! :-)

Whats the best SQL server platform to use with Delphi and why?  

I understand InterBase is easiest to set up and use, but I'm concerned
about performances which I'm told significantly lags behind Oracle and
Sybase, etc..

Is InterBase on an 166 Intel machine with Novell better or worse than
InterBase on Windows NT Server on a RISC machine? (i.e. NECs)?

What about MS-SQL Server and that whole backoffice she-bang?

I am courting a potential customer who already has 250,000 records in
their current database.  It is evident that they need to move to an SQL
server, but it has been years since I last worked on a SQL server and I
know the playground has changed dramatically since.  Please comment or
tell me where I can get direct comparisions of the different platforms.

Regards,

Mike
--

|| Vice-President,         Real Estate Software Concepts, Inc. ||
||   "What a good thing Adam had - when he said a good thing,  ||
||    he knew nobody had said it before."  -- Mark Twain       ||
[]================= http://www.***.com/ ~mlang/mlang.html ==[]



Mon, 22 Feb 1999 03:00:00 GMT
 Best SQL Server?

Hi,

Whatever you do, don't use interbase for novell. It's the slowest solution
for medium to large databases.
I don't know about other SQL database servers, but Interbase performs MUCH
better on windows NT.
We have moved from novell to NT and gain an average performance boost up to
300% on heavy database functions like updating and joined queries.

Bye,
        Scott.



Quote:
> I'm looking to start a war! :-)

> Whats the best SQL server platform to use with Delphi and why?  

> I understand InterBase is easiest to set up and use, but I'm concerned
> about performances which I'm told significantly lags behind Oracle and
> Sybase, etc..

> Is InterBase on an 166 Intel machine with Novell better or worse than
> InterBase on Windows NT Server on a RISC machine? (i.e. NECs)?

//**//


Tue, 23 Feb 1999 03:00:00 GMT
 Best SQL Server?

Hi Mike

ML> Whats the best SQL server platform to use with Delphi and why?

IMO Delphi works well with most of the server platforms. The question
should be whether or not to use native drivers (Borland SQL-Links) or
ODBC, i.e. is the high cost of Delphi Client Server justified for the
additional functionality vs the lower cost and lesser functionality of
Delphi Developer using ODBC?

ML> Is InterBase on an 166 Intel machine with Novell better or worse than
ML> InterBase on Windows NT Server on a RISC machine? (i.e. NECs)?

Stay away from Novell when it comes to databases. Novell has never been
a good application server - rather go for UNIX or NT. I would recommend NT -
it is much easier to administer and has a shorter learning curve than
UNIX.

ML> What about MS-SQL Server and that whole backoffice she-bang?

Cheaper option I think and maybe the best for your setup. SQL-Server 6.51
has matured nicely and is very easy to administer - as oppose to Oracle
on NT for example. I've also written Delphi client-server systems for
SQL-Server 6.x without any major problems.

ML> I am courting a potential customer who already has 250,000 records in
ML> their current database.  It is evident that they need to move to an SQL
ML> server, but it has been years since I last worked on a SQL server and I
ML> know the playground has changed dramatically since.  Please comment or
ML> tell me where I can get direct comparisions of the different platforms.

What you'll quite likely get is a lot of marketing and sales bullshit, with
each trying to knock the competition <pretty pathetic IMO>. At the end of
the day, all the well-known RDBMS's can do the job fairly well.

The choice of the database should be based on the environment it is going to
be used in, i.e. integration with existing network and server infrastructures,
skill levels of the administrator(s) responsible for the server and database
systems, etc. I would for example not recommend Oracle in an environment where
the database will not grow larger than 5 Gbyte with more than a 100 users.
SQL-Server and NT can handle this load fairly well. But if the environment
is going to grow to 200+ users and the database to a 100+ GByte I would for
example recommend using Oracle and UNIX as neither NT or SQL-Server support
high-end SMP or MPP platforms yet.

IMO there is no straight answer to what database and o/s to use - the
circumstances, IT environment and user/business requirements are always
unique. And these requirements should be the basis for the decision of
what to use - and not the {*filter*}from the sales and marketing people.

<as you can see I have very little respect for sales people or the reports
being fed to the user & business communities from marketing and other so-
called "independent" experts :-) >

regards,
Billy

 * RM 1.31 3337 *



Mon, 01 Mar 1999 03:00:00 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. Better SQL Server tools than Query Analyzer???

2. Good SQL Server 2000 Books

3. Good SQL Server 7.0 Sites wanted !

4. Any good SQL Server web sites?

5. Good SQL Server Resources

6. Good SQL Server Books MCSE Test

7. Must see IT site(including good SQL server links)

8. Good SQL Server 2000 book

9. Look for a good SQL Server 2000 training

10. Windows 2000 settings for best SQL Server performance

11. Most Cost Effective/Best Sql Server

12. Good Sql Server Sites


 
Powered by phpBB® Forum Software