a lot of tables in mysql
#1

Hi,

What mysql search faster, for ex i have 5 mil tables, like

table_1, table_2 .... table_5000000

If i do query SELECT * FROM table_%d it's will be faster than if i create one table table and there make 5000000 insert and do

SELECT * FROM table
Reply


Messages In This Thread
a lot of tables in mysql - by Bussyman - 11.04.2017, 17:57
Re: a lot of tables in mysql - by Vince - 11.04.2017, 19:04

Forum Jump:


Users browsing this thread: 1 Guest(s)