Order fields are created in

Discuss the HanDBase for Windows Desktop program, conduits, and add-ons.

Order fields are created in

Postby Gab-Hop » Sat May 23, 2015 8:31 pm

I have some DBs that are quite slow to start up and i am wondering if there are any particular ways in which they should be created that will help with this
I have data coming in from a parent DB through relationship fields and from here it is used as part of calculated formula's
Would it help to reorder some fields so that all calculated fields work down in order.
And to put the relationship fields as some of the first fields in the DB so that the calculations are done after them
Are there any rules regarding the field order creation in more complex DBs like this ?
Gab-Hop
 
Posts: 45
Joined: Mon Jan 13, 2014 11:34 pm
Location: New Zealand

Re: Order fields are created in

Postby mjhanna » Sun May 24, 2015 10:51 am

I don't know if there are "rules" but had always believed that for any Calculated or Conditional fields the fields which they depend upon should come before them.
Michael
(Only a user and not affiliated with DDH Software, but working with computer databases for over fifty years.)
mjhanna
 
Posts: 155
Joined: Tue Oct 15, 2013 10:56 am
Location: New Mexico

Re: Order fields are created in

Postby Brian_Houghton » Wed May 27, 2015 9:03 am

Reordering the fields won't have any bearing on speed, unfortunately.

The hit in speed is caused by the calculations and relationships themselves, being updated upon opening.
Kind Regards,
Brian Houghton, DDH Software
Brian_Houghton
 
Posts: 2246
Joined: Wed May 20, 2009 8:30 am


Return to HanDBase for Windows

Who is online

Users browsing this forum: No registered users and 1 guest