Re: [Maria-discuss] doubt about merge table (10000+) with same structure

2015-09-23 Thread Justin Swanhart
n/5.5/en/partitioning.html which the optimizer > should be able to take advantage of. > > From: Maria-discuss > [mailto:maria-discuss-bounces+rhys.campbell=swisscom@lists.launchpad.net] > On Behalf Of Roberto Spadim > Sent: Wednesday, September 23, 2015 4:06 AM > To: Maria

Re: [Maria-discuss] doubt about merge table (10000+) with same structure

2015-09-23 Thread Justin Swanhart
[mailto:maria-discuss-bounces+rhys.campbell=swisscom@lists.launchpad.net] >> On Behalf Of Roberto Spadim >> Sent: Wednesday, September 23, 2015 4:06 AM >> To: Maria Discuss >> Subject: [Maria-discuss] doubt about merge table (1+) with same structure >>

Re: [Maria-discuss] doubt about merge table (10000+) with same structure

2015-09-23 Thread Roberto Spadim
ally, it would be a good idea to merge all your data into a single > table. Perhaps use partitioning > https://dev.mysql.com/doc/refman/5.5/en/partitioning.html which the > optimizer should be able to take advantage of. > > > > *From:* Maria-discuss [ > mailto:maria-discuss-boun

Re: [Maria-discuss] doubt about merge table (10000+) with same structure

2015-09-23 Thread Rhys.Campbell
: Maria-discuss [mailto:maria-discuss-bounces+rhys.campbell=swisscom@lists.launchpad.net] On Behalf Of Roberto Spadim Sent: Wednesday, September 23, 2015 4:06 AM To: Maria Discuss Subject: [Maria-discuss] doubt about merge table (1+) with same structure Hi again guys :) i'm with a new problem

[Maria-discuss] doubt about merge table (10000+) with same structure

2015-09-22 Thread Roberto Spadim
Hi again guys :) i'm with a new problem i have MANY (1+) tables with same struct, and i want to execute a select from "some" (100+) tables i was thinking about creating a view with all tables, something like: CREATE VIEW view_name AS SELECT * FROM table1 WHERE primary_key= UNION ALL SELECT