Re: INSERT performance

Also watch out for indexes, if the Insert performance is critical. Each Insert automatically updates the indexes so the fewer the indexes, the better (from this perspecitve). (And don't forget that many constraints, such as foreign key, implicitly involve indexes).

A lot of 'professional' systems have 'API' tables with only the key to ensure ultrafast inserts, followed by periodic transfer to the live tables.

/Hans

Connor McDonald wrote:

> mao_guang_at_my-deja.com wrote:
> >
> > Hi, all:
> >
> > I want to improve the performance of INSERT performance of my Pro C
> > program.However,i have no knowledge of this field,so i have to do
> > commit every 5 times.I know it is ugly,could anyone do me a favor ?
> >
> > Regards
> >
> > Mao Guang
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
>
> The fewer commits the faster it will run (typically...)
>
> HTH
> --
> ===========================================
> Connor McDonald
> http://www.oracledba.co.uk (mirrored at
> http://www.oradba.freeserve.co.uk)
>
> "Early to bed and early to rise,
> makes a man healthy, wealthy and wise." - some dead guy
  Received on Sat Nov 18 2000 - 18:23:40 CST