Re: How to set FILLFACTOR

From: Jéjé (willgart_at_BBBhotmailAAA.com)
Date: 12/30/04 

Date: Thu, 30 Dec 2004 12:30:16 -0500

best way:
delete all indexes, fill the table, recreate the indexes.

second option:
disable constraint validation, load the table, defrag your indexes after
loading the table
disabling the constraint like foreign key check etc... improove the
performance, but the index creation time degrade the performance. (but make
sure you load valid data in your table)

"Nags" <nags@RemoveThishotmail.com> wrote in message
news:ufTYvko7EHA.2124@TK2MSFTNGP14.phx.gbl...
>I need some help on how to improve performance when loading tables.
>
> We have a datawarehouse and sometimes it is needed that the entire
> datawarehouse is refreshed. (like when test is refreshed from production)
>
> The datawarehouse tables are refreshed by a set of sql statements. Take
> for
> example there is a COMPANY table, the data is denormalized with the
> address,
> and user information stored along with company information. In order to do
> that, initiallly company information is populated and then address & user
> information is updated to it. In this entire process, all indexes except
> the clustered index is dropped at the beginning of the process and
> recreated
> at the end of the data load. In order to improve the process, if I set
> the
> FILLFACTOR to 10 or 20 on the clustered index, will it really help ? I
> understand from the documentation that FILLFACTOR is used only when the
> index is created, so if I loading data to an existing table, FILLFACTOR
> will
> be of no use, correct ?
>
> Is there anything else that I can do to imporve the performance of such
> table loads. All loads are with first inserting core data and then
> updating
> the related data.
>
> The database is already set to SIMPLE mode.
>
> -Nags
>
>

Relevant Pages

  • Re: Next Version of GDI+ (maybe GDI+ 2.0)
    ... loading and manipulating of such files isn't lightning fast unless you have really powerfull dedicated hardware. ... to see whole image you need to read whole image, and then eventualy generate a smaller sample for display. ... BUT to have this smaler sample you need to load ALL the pixels of oryginal image. ...
    (microsoft.public.dotnet.framework.drawing)
  • RE: 66 running processes?
    ... Win XP, a firewall and an AV and about seven background utilities, and with ... want it to load right from boot up, or could you take it off the load list ... Stopping programs you use loading early is only likely to make much ...
    (microsoft.public.windowsxp.perform_maintain)
  • Re: Next Version of GDI+ (maybe GDI+ 2.0)
    ... Alejandro Lapeyre ... > loading and manipulating of such files isn't lightning fast unless you ... > smaller sample for display. ... > load ALL the pixels of oryginal image. ...
    (microsoft.public.dotnet.framework.drawing)
  • Re: Filter on a forms recordsource
    ... What I'm trying to do is to load a record with its sub details in a subform. ... without loading the whole records and details of the database. ...
    (microsoft.public.access.queries)
  • Re: MVP please help - ShowDialog() very slow
    ... You should also consider using asynchronous delegates to load your data. ... can either disable the listbox while the data is loading or show some kind ... > You need to remember that the ListBox control is a wrapper around the old ... >>when the list box switches to visible as part of ShowDialog(). ...
    (microsoft.public.dotnet.framework.windowsforms.controls)