From: Ad 

Geo wrote:
> "Adam" <""4thwormcastfromthemolehill\"{at}the
field.near the bridge"> wrote in
> message news:454fdd07{at}w3.nls.net...
>
>>> I use Progress databases on Unix and SQL server on NT, trust me on this,
> sql
>>> server really is a nice DB engine. It's just overpriced like all the
> other
>>> db's.
>
>> Oh indeed. I've just done a switch for a j2ee thing for the nhs from
>> sqlserver to mysql/innodb (needed transactions). Both db'es are on
>> windows (it's not a massive app (a vocab server)) but it was the
>> portability which was a required feature.
>>
>> To me so long as it's sql92 & solid......then shrug.
>
> I've got the sql92 drivers for the progress database, but when you try to
> use a dropdown box that shows all the values in an index so you can pick
> one, it's dog slow with progress and lightening fast with sqlserver. Also
> compacting the database is a hell of a lot easier on sql server (most
> maintenance tasks are automated or really easy to automate) while on unix I
> still have to do a dump and load to compact the stupid db.
>
> Geo.
>
>
wrt the last point, that depends on the db. Progress may require that but
DB2, Oracle etc don't. In MySql it's "OPTIMIZE TABLE".

Adam

--- BBBS/NT v4.01 Flag-5