Re: IBM could buy Sun?

Sun only worth 6.5 billions? -- - Lin Chun

Open source Data warehouse

Hi Anybody know some open source data warehouse product like Bizgres?

Does mysql support materialized views?

Hi I am now working with Mondrian , and need tuning the database, as the materialized views can improve the performance and doesn't need to create the fact tables cheers -- ----- Lin Chun

Re: I thin'k MySQL will be the 'Oracle Personal Edition'

.com/mysql > To unsubscribe:http://lists.mysql.com/mysql?unsub=franks1...@gmail.com > > -- - Lin Chun

Partition of Mysql

s by years, excuse my poor english writing and thank you for your answers -- ----- Lin Chun

Re: how to fetch and calculate data from remote database and insert into local database

s.mysql.com/mysql?unsub=franks1...@gmail.com > > -- - Lin Chun

How can we stock the query result into a text file

ction in Oracle " spool 'filenameandpath.txt' select ... from .. / spool off " does Mysql has such function? -- ----- Lin Chun

Try to create a tunnel SSH to remote DB server, but with error Number 2013

this kind of connenction? Regards, -- - Lin Chun <http://www.brainyquote.com/quotes/authors/f/fred_allen.html>

do i have to restart the mysql server when i change some global variables?

hi as the title thanks -- - Lin Chun

how to avoid sub-query to gain performance

7;, 'fk_agr_synthese_activite_media_fa_agent_centre_contact,fk_agr_synthese_activite_media_fa_agent_direction_contact,fk_agr_synthese_activite_media_fa_agent_file_attente,fk_agr_synthese_activite_media_fa_agent_media,fk_agr_synthese_activite_media_fa_agent_th_heure', NULL, NULL, NULL, '20903', 'Using where; Using join buffer' '2', 'DERIVED', 'cc', 'eq_ref', 'PRIMARY', 'PRIMARY', '4', 'reporting_acd.a.Id_Centre_Contact', '1', '' '2', 'DERIVED', 'f', 'eq_ref', 'PRIMARY', 'PRIMARY', '4', 'reporting_acd.a.Id_File_Attente', '1', '' '2', 'DERIVED', 'dc', 'eq_ref', 'PRIMARY', 'PRIMARY', '4', 'reporting_acd.a.Id_Direction_Contact', '1', 'Using where' '2', 'DERIVED', 'm', 'eq_ref', 'PRIMARY', 'PRIMARY', '4', 'reporting_acd.a.Id_Media', '1', 'Using where' *don't know it very clear, but i think is the problem of seems it take full scaning* * * *than i change all the sub-query to views(create view as select sub-query), and the result is the same* *thanks for any advice* -- - Lin Chun