I am having 3 tables user, songs and age table the user and songs having user_id each having 200k records suppose i need to make a range like selecting the records from age where age is more than 20 and from songs table the songs which is released after 2000
The virtual join table of mysql does nt work for this scenario as it taking more than 2 hours to construct the virtual table as it is exponential
I had tried using fetching the datas to the main memory and then make a intersection of both the datas retrived from tables but fetching the datas from tables to main memory takes 10sec appr for each retrival how can i optimise this