commons-app / commonsmisc

4 stars 5 forks source link

Optimise query for getting log_title and log_page #10

Closed maskaravivek closed 5 years ago

maskaravivek commented 5 years ago

Query for getting log title [Used twice]:

select log_title from logging_userindex where log_type="upload" and log_user=%d

Query for getting log page [Used once]:

select log_page from logging_userindex where log_type="upload" and log_user=%d

Both the above queries can be merged into one and would save us some time. Instead of querying the database 3 times, it would be queried once.

select log_title, log_page from logging_userindex where log_type="upload" and log_user=%d

PS: Am working on fixing this.