search

cham / TeslaAPI

Tesla forum database and RESTful API
11 stars 9 forks source link

thread sorting performance #5

Closed cham closed 11 years ago

cham commented 11 years ago

applying sorting to getThreads increases query time by 100-200% on large collections (million+ comments). Adding an index helps but we should optimise this for at least the default sorting (last comment time).

cham commented 11 years ago

this has largely been mitigated by indexing last_comment_time so I'm closing