Forum Moderators: open

Message Too Old, No Replies

Large table influence performance of small table in MySQL database

Django website database growing pretty fast

         

willemgroenewald

8:38 pm on Oct 8, 2009 (gmt 0)

10+ Year Member



I'm running Django framework using a MySQL database. I launched the site on Monday and in the beginning I only logged the location and MSISDN (Mobile number) of people that bought a video from my portal. Tonight I also started to log the MSISDN and location with each page impression. The thing is, it is way out of peak time and I'm getting about 10 page impressions per minute which means that eventually this table will grow to be pretty big.

I am a bit worried, because the rest of my portal uses the same database but different tables for rendering purposes which should of course be as fast as possible.

My question is, will this big table influence the speed at which the smaller table performs?

And, what would you recommend, should I maybe run a script every night to move all the information over to another database?