Marul,
It sounds to me like the indexes are going into overflow - this will
cause the insert time to increase. I would suggest batching up the
inserts, dropping the indexes, running the inserts and re-creating
the indexes.
Chris
|
- Inserts are taking time ! Marul Mehta
- Re: Inserts are taking time ! Anjo Kolk
- Re: Inserts are taking time ! Justin Cave
- Re: Inserts are taking time ! Marul Mehta
- RE: Inserts are taking time ! Naveen Nahata
- RE: Inserts are taking time ! chris . w . johnson
- RE: Inserts are taking time ! Nicoll, Iain \(Calanais\)
- Re: Inserts are taking time ! Jared Still
- RE: Inserts are taking time ! chris . w . johnson
- RE: Inserts are taking time ! Jared . Still
- Re: Inserts are taking time ! Marul Mehta
- Re: Inserts are taking time ! Marul Mehta
- RE: Inserts are taking time ! Naveen Nahata
- RE: Inserts are taking time ! chris . w . johnson
- RE: Inserts are taking time ! Deshpande, Kirti
- Re: Inserts are taking time ! Marul Mehta