Page 1 of 1
Faster synchronization for all tables
Posted: Wed Aug 16, 2017 3:30 pm
by cheemingyong
Right now i am encountering speed issues as i have more than 50 tables in my database schema
when i tried to synchronize the database.
I only need to use 5 tables out of the 50 and I was wondering if there's a faster way to synchronize
as the asp.net maker actually reads all of the tables for synchronization when it should only
synchronize those tables that I want to be generated.
this actually affects the time i spent on development
Re: Faster synchronization for all tables
Posted: Thu Aug 17, 2017 11:30 am
by motfs
You can use the feature "Dynamic Table Loading" before pressing "Connect" button. Read Database Setup -> Dynamic Table Loading in help file for more detail.
Re: Faster synchronization for all tables
Posted: Thu Aug 17, 2017 2:06 pm
by cheemingyong
hi i tried what you told me and it give me a warning saying that if i continued all current settings will be lost
and after i clicked on connect, all my tables are deselected from the database panel
is there something i am doing wrong ????
Re: Faster synchronization for all tables
Posted: Thu Aug 17, 2017 2:11 pm
by cheemingyong
hi i think your correct answer should be to right click on the table from the database panel and
choose synchronize table / view
i believe this is more appropriate for most of the developers using the ASP.NET maker
we normally make changes to one table at one time then we sync instead of so many tables at one go
Re: Faster synchronization for all tables
Posted: Fri Aug 18, 2017 10:04 am
by motfs
You can use the feature "Dynamic Table Loading" before pressing "Connect" button.
Maybe, it is not very clear for the above statement that pressing "Connect" button only if you start a new project. If you read the help file, you need to enable the option "Dynamic Table Loading" when you start a new project (not existing project).