Hi Folks. I've run you Database Designer, but my queries are now about 25% slower. I posted this at why does running the database designer result in poorer performance?, but I've decided to revert to the default superprojections, which worked better for me. How do I do that? Thanks in advance.
how do I restore the default superprojections after running Designer?
+1
+2Sorry that nobody replied yet!
I am not sure if you still have the issue but there is not an automatic way to recreate the default superprojection. what you can do is create table_new as select * from table_old limit 0; so it copies the table structure and then do insert into table_new select * from table_old and when the data is copied, drop table_old and then rename table_new to table_old. Hope this make sense.
However, the DBD should propose a better projection. I am wondering what the DBD deployed and it could had be related to the data type. Did you have a good sample?
HTH,
Eugenia
I am not sure if you still have the issue but there is not an automatic way to recreate the default superprojection. what you can do is create table_new as select * from table_old limit 0; so it copies the table structure and then do insert into table_new select * from table_old and when the data is copied, drop table_old and then rename table_new to table_old. Hope this make sense.
However, the DBD should propose a better projection. I am wondering what the DBD deployed and it could had be related to the data type. Did you have a good sample?
HTH,
Eugenia
+1Hi Eugenia!
DBD creates a schema backup before deployment, so its very easy to restore it, whith out recreation a table - just extract a project from schema dump.
DBD creates a schema backup before deployment, so its very easy to restore it, whith out recreation a table - just extract a project from schema dump.
Sign up
Already have an account? Login
Welcome to the Rocket Forum!
Please log in or register:
Employee Login | Registration Member Login | RegistrationEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.
77 4th Avenue
Waltham, MA 02451 USA
