Re: inserts take longer and longer

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Le mar. 20 nov., vers 15:55, David Modica exprimait :

> hi all. 

Hi,

> I hope this is the correct way to get help from the list.
[...]
> we have a developer who is doing batch inserts 20 at a time and each
> subsequent batch is taking longer to the point where it is a
> critical problem. I recently changed the out of the box config to
> see if that would help but it hasn’t:
[...]
> any direction as to what to look at would be appreciated.

When you're doing bulk insert, it's a good practice to drop index and
recreate it after.

Regards,
-- 
Stéphane KANSCHINE - https://www.hexack.fr./ - https://www.nuajik.io./
@ stephane@xxxxxxxxx
  +33 6 64 31 72 52




[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux