Re: specific partitioning by varchar column

[Atanas Todorov]

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.