Database optimalisation

minutils / feed-on-feeds

Released in 2003, saw the rise and fall of Google Reader, reached perfection in 2011

http://feedonfeeds.com/

GNU General Public License v2.0

14 stars 9 forks source link

Database optimalisation #30

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago

Currently the whole project is great. Can you please post the most optimal 
indexes when having +300.000 headlines in the database. Now the updating 
takes for ages (deleting of old posts takes very long ±10 seconds)

Please help

Original issue reported on code.google.com by di...@dijksma.net on 29 Oct 2007 at 7:34

GoogleCodeExporter commented 9 years ago

Wow, and I thought I had a lot of feeds!  I'll see what I can do.

Original comment by stevemin...@gmail.com on 9 Dec 2007 at 3:51

Changed state: Accepted

GoogleCodeExporter commented 9 years ago

Hi,
I changed most of the primary key columns to unsigned int which are of smaller
size than te default column sizes an result in smaller indices.
I changed some indexes to prefixed ones especially in the fof_item table
because some of them got unecessary large.
I changed the default table type to InnoDB as well, which results in less
disk reads because data and indexes can be kept in memory.
Drop me a mail if you're interested in the schema.

Original comment by shaiman....@gmx.de on 19 Mar 2009 at 4:46

GoogleCodeExporter commented 9 years ago

Hi shaiman..., could you please tell me how to optimize the database, i have 
greater
than 7 lakhs items in the database and it takes me long time to update and 
display
the items.

I am updating feeds using cron job for every 4 hour. This is my gmail ID
scvinodkumar.php@gmail.com. 

If u share your scheme, that would be great. Waiting for your reply.

Original comment by scvinodk...@gmail.com on 9 Oct 2009 at 2:10