Modify ↓

Opened 20 years ago

Closed 20 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 20 years ago by anonymous

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

comment:2 Changed 20 years ago by Alec Thomas

Resolution: → fixed
Status: new → closed

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.

Attachments ↑ Description ↑
 
Note: See TracTickets for help on using tickets.