var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: How i Optimize my db i have a lot of record
Hello first I should say that my english very bad im so sorry (im turkish)
my database have 2 table
1. table name users
user_id - user_rate - user_credit
1 2 10
2 2 10
3 3 10
4 4 10
2.table name log
i have log table 10.000 + record (facebook page like desktop application work with php)
I'm doing query 2 times per second average
my host enrollment increases, slowing down
how i optimize my db or how i transform another mysql type
and need i move my db to vps ?
thanx for comment but im sorry my english
do your tables have the correct indexes?
i dont know
what is the index
im beginner in mysql and php but my application is growing rapidly
i need fix this problem but How ?
What are the advantages of using index?
do a search for mysql optimization -- it will tell you which columns should be indexed
Thanx for help