> On my website i have a tabel where i log some web requests - about
> 90.000/hour.
> 
> Every hour this SQL is executed in a stored procedure:
> delete from requests where created < dateadd(-7 day to
> current_timestamp);

Do you have an index on "created"?


Sean

  • [firebird-supp... kragh.tho...@yahoo.com [firebird-support]
    • RE: [fire... 'Leyne, Sean' s...@broadviewsoftware.com [firebird-support]
      • [fire... kragh.tho...@yahoo.com [firebird-support]
    • Re: [fire... Helen Borrie hele...@iinet.net.au [firebird-support]
      • Re: [... kragh.tho...@yahoo.com [firebird-support]
        • R... Tim Ward t...@telensa.com [firebird-support]
          • ... kragh.tho...@yahoo.com [firebird-support]
            • ... 'livius' liviusliv...@poczta.onet.pl [firebird-support]
        • R... Alexey Kovyazin a...@ib-aid.com [firebird-support]
          • ... 'Leyne, Sean' s...@broadviewsoftware.com [firebird-support]
    • Re: [fire... 'Mark Rotteveel' m...@lawinegevaar.nl [firebird-support]
    • Re: [fire... 'Mark Rotteveel' m...@lawinegevaar.nl [firebird-support]

Reply via email to