EPrints Technical Mailing List Archive

See the EPrints wiki for instructions on how to join this mailing list and related information.

Message: #03993

< Previous (by date) | Next (by date) > | < Previous (in thread) | Next (in thread) > | Messages - Most Recent First | Threads - Most Recent First

[EP-tech] Re: DB slow down.

Il 26/02/2015 13:03, Ian Stuart ha scritto:

On 26/02/15 11:57, Adam Field wrote:

Clearing out the indexer queue may not be a bad idea, but you will
need to then reindex everything anyway (and potentially regenerate
all thumbnails), and there may be other things on the queue...


We don't use thumbnails (as well as no full-text searching)

The GUI stuff is all secondary to the main service


Note also, that as the size of the queue reduces, the speed may
increase significantly as it may be the size of the queue that's
making it so slow.

This would be nice ;-)




Hi all,

Could be useful to delete the duplicated records eventually present in the event__queue ?
Maybe this could speed up the indexing.
Indexing two (n) time the same record is a time and cpu waist.
You have to do some sql trick to isolate the right records ...

Best regards,
Paolo



--
Ing. Paolo Tealdi         Area IT - Politecnico Torino
Telefono/Phone : +39-011-0906714 , FAX : +39-011-0906625
Indirizzo/Address : C.so Duca degli Abruzzi,  24 - 10129 Torino - ITALY
Skype : tealdi.paolo
Please consider your environmental responsibility before printing this e-mail