hello

here are the facts:
- 2 tables: `table1` and `table2` that have the SAME structure
- `table1` about 30.000 rows
- `table2` about 170.000 rows - this table is updated more often
- i have to display the data in a grid with pagination with results from both `table1` and `table2`

i've did the following:
CREATE TEMPORARY TABLE `table_tmp` LIKE `table1`;
ALTER TABLE `table_tmp` ENGINE=MERGE UNION=(`table1`,`table2`);
ANALYZE TABLE `table_tmp`;

SELECT SQL_CALC_FOUND_ROWS
[...]
FROM `table_tmp`
WHERE
[...]
LIMIT 0, 20


is this the best method to work with the tables?
i find it kind of slow. please share your thoughts.
sometime i get this kind of error: Table 'table_tmp' is marked as crashed and should be repaired
thanks!

actually with UNION ALL the query is much slower

with temporary table MERGE i get the following results:

CREATE TEMPORARY TABLE 0.001532
ALTER TABLE UNION 0.002059
mysql_query = 2.613590
mysql_num_rows 0.000009
FOUND_ROWS 0.000086
mysql_result 0.000019
mysql_free_result 0.000008
119496 rows returned


I dont like the fact that the mysql_query has the execution time of 2.6 seconds