Changes between Initial Version and Version 1 of Ticket #23830, comment 3


Ignore:
Timestamp:
Nov 16, 2014, 4:21:36 AM (10 years ago)
Author:
Ilja Maas

Legend:

Unmodified
Added
Removed
Modified
  • Ticket #23830, comment 3

    initial v1  
    1 The patch is a partial improvement because it does not instantiate all the objects. However using 'IN' query statements is not quite fast (to say it nicely) in most DB's. As whereof I think it won't be faster in general. (not tested though)
     1The patch is a partial improvement because it does not instantiate all the objects. However using 'IN' query statements with a huge number of ids in it is not quite fast (to say it nicely) in most DB's. As whereof I think it won't be faster in general. (not tested though)
    22
    33Actually in this specific case a 'DELETE FROM session WHERE expire_date<'20XX-XX-XX' would deliver a huge performance boost, as the expire_date field is DB indexed and it will not create a long running transaction in which the records are deleted one by one.
Back to Top