Bug 18605 - please, optimize SQL query
Summary: please, optimize SQL query
Status: CLOSED FIXED
Alias: None
Product: Sisyphus
Classification: Development
Component: repocop-unittest-big-changelog (show other bugs)
Version: unstable
Hardware: all Linux
: P2 enhancement
Assignee: viy
QA Contact: qa-sisyphus
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2009-01-22 22:59 MSK by viy
Modified: 2009-03-27 09:50 MSK (History)
3 users (show)

See Also:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description viy 2009-01-22 22:59:47 MSK 
в
SELECT pkgid FROM rpm_files WHERE filename GLOB '/usr/share/doc/*/ChangeLog' AND
 filesize > 200000 ORDER BY filesize;
желательно бы ORDER BY filesize убрать, сэкономить пару секунд на песочнице.
Comment 1 Igor Zubkov 2009-02-07 20:22:32 MSK 
делай NMU
Comment 2 viy 2009-02-07 22:47:03 MSK 
ok
Comment 3 Igor Zubkov 2009-03-25 18:45:05 MSK 
Fixed in 0.2-alt1
Comment 4 viy 2009-03-25 18:56:50 MSK 
спасибо, а то руки не доходили.
Comment 5 Slava Semushin 2009-03-27 09:50:54 MSK 
Кстати, можно ещё сделать аналогичную проверку для NEWS файлов.