search

kihashi / mtg-irc

A module for the IRC Bot Phenny that allows users to query magic cards.
3 stars 1 forks source link

Add prices is really slow #60

Closed kihashi closed 9 years ago

kihashi commented 9 years ago

It took about 4 minutes on my laptop. Would MySQL over SQLite improve the times?

kihashi commented 9 years ago

I think the way to fix this is to deploy on with real SQL and have a cron job run the import script every day.

kihashi commented 9 years ago

This is now on a cron job to run the price update script every day at 4AM. I am still using SQLite as writing while reading is happening is not a problem.