Hi,

I tried migration and decided just to migrate the data structure, the data importing will be done by my own code with optimized speed, but since there are several things that need to be tuned like CLOB compression and COLLATE etc, I decided to delete several tables that is similar in their field name, the differences is just in the Table Name

I use

CREATE TABLE History0902 (LIKE History1009);

and refresh the Explorer, but the table History0902 doesn't show up in the Tree View, but can be viewed using SQL Query like SELECT * FROM History0902

and the Refresh took along time to complete, I already put ElevateDB Manager into exclusion in Kaspersky, but still the same.

Regards,


Surjanto

Tim,

I tried the CREATE TABLE statement at home and it doesn't happen, I think it could be Kaspersky blocking something, will let you know if I can replicate this error

Regards,


Surjanto

Surjanto,

First of all, what version are you using?
Also, you are migrating from what?


Fernando Dias
[Team Elevate]



Em 12-10-2010 12:05, Surjanto Kwe escreveu:
> Hi,
>
> I tried migration and decided just to migrate the data structure, the data importing will be done by my own code with optimized speed, but since there are several things that need to be tuned like CLOB compression and COLLATE etc, I decided to delete several tables that is similar in their field name, the differences is just in the Table Name
>
> I use
>
> CREATE TABLE History0902 (LIKE History1009);
>
> and refresh the Explorer, but the table History0902 doesn't show up in the Tree View, but can be viewed using SQL Query like SELECT * FROM History0902
>
> and the Refresh took along time to complete, I already put ElevateDB Manager into exclusion in Kaspersky, but still the same.
>
> Regards,
>
>
> Surjanto
>

Hi Fernando,

I am using 2.04 b4, and migrating from NexusDB

Regards,


Surjanto

Surjanto,

<< I use

CREATE TABLE History0902 (LIKE History1009);

and refresh the Explorer, but the table History0902 doesn't show up in the
Tree View, but can be viewed using SQL Query like SELECT * FROM History0902
>>

Are you sure that you created the table in the correct database ?

<< and the Refresh took along time to complete, I already put ElevateDB
Manager into exclusion in Kaspersky, but still the same. >>

That could be Kapersky interfering, but how many tables/views, etc. are in
the database ?  Sometimes it may take a couple of seconds to refresh the
schema for a very large database (200+ tables with lots of columns).  Also,
the refresh time is dependent upon what portion of the treeview you
currently have selected when you refresh.  The higher up the tree, the more
that will be refreshed, and the longer that it will take.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim,

It was 322 tables <BG>

I might need a new computer for this, still using the old and good athlon
3200+ ...

Regards,


Surjanto

Tim,

Confirmed, after I remove a lot of files, it is smooth, any plans to fix
this ? I can not reduce the number of table, in fact, it will grow each
month, since I separate each month history file.

Regards,


Surjanto

Surjanto,

<< Confirmed, after I remove a lot of files, it is smooth, any plans to fix
this ? I can not reduce the number of table, in fact, it will grow each
month, since I separate each month history file. >>

There really isn't anything to "fix".  If you have a lot of tables, it's
simply going to take a while to refresh the treeview from the higher levels
in the database.  The treeview internally indexes its nodes so that searches
for nodes are as fast as possible during population and refreshing.

--
Tim Young
Elevate Software
www.elevatesoft.com