I wonder is it possible to split 1 phpnuke sql in 3-4 smaller ones so server load and querry will be fast. Usually you have between 127 tables + extra if you install something then it goes up.. I have sql that is over 500 mb and i was wonder is there a way to split this sql in smaller ones..

Maybe this sound funny but i was thinking is great idea but i dont know is it possible?

Anyone know anything about this ?