Oracle and IBM�s market share of the RDBMS sector vastly exceeds SQL Server if for no other reason than they are not limited to Windows. Gartner�s latest survey puts Oracle at about 32% of the market and IBM at 30% with SQL Server somewhere around 14%. SQL Server is dominant in the Windows market only and it is frankly not that prominent in the upper tier server sector.
Michael
Michael Barry
Aspacia Systems Inc
866.566.9600
312.803.0730 fax
http://www.aspacia.com/
Michael
Michael Barry
Aspacia Systems Inc
866.566.9600
312.803.0730 fax
http://www.aspacia.com/
On Jun 11, 2013, at 9:16 AM, Vic Drecchio <vic.drecchio@...> wrote:
> Exactly... Sans Oracle, how popular are the rest? IBM's U2 (Rocket
> Software) and DB2 db's also have other unique characteristics that make them
> a PITA (multi value fields?)
>
> In the evolution of database engines, one thing clustered indexing solved
> was the need to perform D&L's. I didn't realize Oracle still had that
> ability. It just makes no sense, IMO. Perhaps that's why Microsoft SQL,
> MySQL and Postgres have continued the upward db dominance trend while the
> others are drifting away. Again, besides Oracle..
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
> Michael Barry
> Sent: Tuesday, June 11, 2013 11:28 AM
> To: vantage@yahoogroups.com
> Subject: Re: [Vantage] Dump & Load Instructions (Vantage 6)
>
> Hi Vic,
>
> Actually almost all RDBMS's that are not Sybase derivatives have some form
> of export,truncate and reload function for optimizing the database. Oracle,
> DB2, Informix, Versant, et al all have this basic technique for compressing
> and rebuilding the database. Some, including Oracle can even do it online
> on a table by table basis at runtime.
>
> That being said, performance improvements from a D & L with Progress are
> only achieved when performed on a very highly fragmented DB, if then.
>
> Regards,
>
> Michael
>
> Michael Barry
> Aspacia Systems Inc
> 866.566.9600
> 312.803.0730 fax
> http://www.aspacia.com/
>
> > I'm glad someone else said it first.. I saw no improvement after
> performing a D&L. So I won't be doing it again.
> >
> > In the real RDBMS world, there is no such thing as a dump and load. Leave
> it to Progress to be archaic.
> >
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of Chris Thompson
> > Sent: Tuesday, June 11, 2013 10:48 AM
> > To: vantage@yahoogroups.com
> > Subject: Re: [Vantage] Re: Dump & Load Instructions (Vantage 6)
> >
> > From what I can gather its just like a defrag for the database.
> >
> > It's meant to improve performance but we have never notices any.
> >
> > Chris Thompson
> >
> > On 11 Jun 2013, at 15:45, "shraderc" <charles.shrader@...
> <mailto:charles.shrader%40gmail.com> > wrote:
> >
> > > Also, what are the advantages of a 'Dump and Load', and is this a
> recommended procedure that should periodically be done for optimization?
> > >
> > > Chuck
> > >
> > > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> "Mike" <mf.zonereed@...> wrote:
> > > >
> > > > Does anyone have Dump & Load Instructions for Vantage 6?
> > > >
> > > > Thanks in advance,
> > > > Mike
> > > >
> > >
> > >
> >
> > [Non-text portions of this message have been removed]
> >
> > [Non-text portions of this message have been removed]
> >
> >
>
> [Non-text portions of this message have been removed]
>
> ------------------------------------
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
> already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder and
> Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
>
>
[Non-text portions of this message have been removed]