Modify

Opened 12 years ago

Closed 12 years ago

#3 closed enhancement (fixed)

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

Reported by: Juanma Barranquero Owned by: Alec Thomas
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 (0)

Change History (2)

comment:1 Changed 12 years ago by anonymous

Summary: Getting the text from the newest revision should use {{{LIMIT 1}}} in SQL clauseGetting the text from the newest revision should use "LIMIT 1" in SQL clause

comment:2 Changed 12 years ago by Alec Thomas

Resolution: fixed
Status: newclosed

Done, thanks for the request.

Modify Ticket

Action
as closed The owner will remain Alec Thomas.
The resolution will be deleted. Next status will be 'reopened'.

Add Comment


E-mail address and name can be saved in the Preferences.

 
Note: See TracTickets for help on using tickets.