SQL improvment

Development-related discussion, including bundled plugins
ldidry
Bear Rating Trainee
Bear Rating Trainee
Posts: 27
Joined: 11 Jun 2013, 20:43

SQL improvment

Postby ldidry » 16 Feb 2017, 11:04


User avatar
fox
^ me reading your posts ^
Posts: 6318
Joined: 27 Aug 2005, 22:53
Location: Saint-Petersburg, Russia
Contact:

Re: SQL improvment

Postby fox » 16 Feb 2017, 11:35

thanks but please use the normal contribution process via gitlab

e: you can also disable feedbrowser altogether via config.php, unless you need the functionality

ldidry
Bear Rating Trainee
Bear Rating Trainee
Posts: 27
Joined: 11 Jun 2013, 20:43

Re: SQL improvment

Postby ldidry » 16 Feb 2017, 12:19


User avatar
fox
^ me reading your posts ^
Posts: 6318
Joined: 27 Aug 2005, 22:53
Location: Saint-Petersburg, Russia
Contact:

Re: SQL improvment

Postby fox » 16 Feb 2017, 12:34

the only thing i need is your gitlab username to give you necessary permissions

e: which is right there in your first post, oh. done.

holyship
Bear Rating Trainee
Bear Rating Trainee
Posts: 1
Joined: 16 Apr 2017, 04:32

Re: SQL improvment

Postby holyship » 16 Apr 2017, 04:37

I also had some performance tuning recently, and I think there is a little optimize on the entries table:

check this: https://tt-rss.org/gitlab/fox/tt-rss/bl ... l.sql#L140

By default, MySQL will create a B tree index for the guid column, but it's better to be hash.


Return to “Development”

Who is online

Users browsing this forum: No registered users and 2 guests