Modify

Opened 19 years ago

Closed 19 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 19 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 19 years ago by Alec Thomas

Resolution: fixed
Status: newclosed

Done, thanks for the request.

Modify Ticket

Change Properties
Set your email in Preferences
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.