davebb

How fast are computations?

Discussion created by davebb on Jun 23, 2017
Latest reply on Jun 24, 2017 by beverly

I am not a developer.  And I have a question about a script I would like to have the database perform, but I am not sure it will work.

 

I have a database where I manually enter all info.  After typing in the date of birth, the db calculates the age and grade.

 

I am working with a developer to create a script that will automatically import records from a csv file.

 

The plan is to do this:

Import all record info from csv to database, including Date of birth

Database calculates age and grade and either updates or leaves untouched the age and grade fields in the db

Database compares the corresponding csv age and grade fields to the (possibly) newly updated db fields

If there are any changes, take some action - not important.

 

The question is this:

Will the database be able to conduct these functions in order, or might the database compare the corresponding csv and db fields, before the fields have a chance to update from the calculation already set up in the db?

Outcomes