Ticket #3 (closed enhancement: fixed)

Opened 7 years ago

Last modified 7 years ago

Getting the text from the newest revision should use "LIMIT 1" in SQL clause

Reported by: Juanma Barranquero Assigned to: athomas
Priority: normal Component: TocMacro
Severity: normal Keywords:
Cc: Trac Release:

Description

I think this would be a small enhancement, at least for heavily modified pages.

  • TOC.py

    old new  
    4343            cursor = db.cursor() 
    44             cursor.execute("select text from wiki where name='%s' order by version desc" % page) 
     44            cursor.execute("select text from wiki where name='%s' order by version desc limit 1" % page) 
    4545            row = cursor.fetchone() 

Attachments

Change History

11/29/04 17:47:49 changed by anonymous

  • summary changed from Getting the text from the newest revision should use {{{LIMIT 1}}} in SQL clause to Getting the text from the newest revision should use "LIMIT 1" in SQL clause.

11/29/04 20:50:23 changed by athomas

  • status changed from new to closed.
  • resolution set to fixed.

Done, thanks for the request.

Add/Change #3 (Getting the text from the newest revision should use "LIMIT 1" in SQL clause)




Change Properties
Action