MySQL Forums
Forum List  »  Partitioning

Re: specific partitioning by varchar column
Posted by: Atanas Todorov
Date: March 20, 2008 02:07AM

Yes, that's the native solution. I'm searching for one that does not include table modification. Actually, if a fast solution exist the idea after that is to convert each of these huge tables (by adding corresponding .frm file to all .arz part files and then remove the original .frm and .par files) to lots of provider-tables.
Another way is to is to execute "insert into ... select * from ... where provider=<provider>" for each provider. Another way is to write a stored procedure that will distribute the table to many provider-tables. Both of them seems to be slow in comparison to the partitioning by provider.

Edited 2 time(s). Last edit at 03/20/2008 05:09AM by Atanas Todorov.

Options: ReplyQuote

Written By
Re: specific partitioning by varchar column
March 20, 2008 02:07AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.