Modify

Opened 10 years ago

Closed 10 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: 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 (0)

Change History (2)

comment:1 Changed 10 years ago 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

comment:2 Changed 10 years ago by athomas

  • Resolution set to fixed
  • Status changed from new to closed

Done, thanks for the request.

Add Comment

Modify Ticket

Action
as closed The owner will remain athomas.
The resolution will be deleted. Next status will be 'reopened'.
Author


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

 
Note: See TracTickets for help on using tickets.