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 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.