[Progress Communities] [Progress OpenEdge ABL] Forum Post: RE: A hundred million rows?

  • Thread starter Thread starter Thomas Mercer-Hursh
  • Start date Start date
Status
Not open for further replies.
T

Thomas Mercer-Hursh

Guest
I think one has to step back and realize that while adding an index to a 100M row table might seem like just adding some reference information, one *is* actually adding 100M pieces of data. While there might be ways to do this particularly quickly with a DB that is inactive and not being replicated, if the DB is active and being replicated, then that is a huge amount of new information being added to the DB and a huge amount of information which must be passed to the replicate. Hence the whole thing taking a long time using SQL and/or with replication active.

Continue reading...
 
Status
Not open for further replies.
Back
Top