Best thing to do it to try it but I suspect your hunch is correct.
Really, 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
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
On 09/23/2015 01:00 AM, Alexander Barkov wrote:
Hi Dan,
On 09/20/2015 12:53 AM, Dan Ragle wrote:
We're converting from MySQL 5.1 to MariaDB 5.5.44 and I'm hoping someone
can help clarify for me what's going on in the following scenario. In
brief, we're getting milliseconds displayed in a part
Hi Dan,
On 09/20/2015 12:53 AM, Dan Ragle wrote:
We're converting from MySQL 5.1 to MariaDB 5.5.44 and I'm hoping someone
can help clarify for me what's going on in the following scenario. In
brief, we're getting milliseconds displayed in a particular date_sub
calculation (and possibly other se
Thanks Justin, but I'm not sure I'm following this.
Is there some way that I can see the differences in what's being
returned from each phase of the operation within the client itself? Each
of these statements:
select substr(datetime,1,13) from test limit 1;
select substr('2015-09-18 09:0
5 matches
Mail list logo
