>>moreover , i'd like to know which is the performance degradation of the sql at the growing of tables size
>
>There's no dirrect correlation between the size of a table and a query performance assuming that you have proper indexes that allows the query optimization. However, the more record the query return the slower it gets.

thank you Sergey