Hello,
I am currently maintaining a legacy application that was developed in ObjectScript and accesses data by working directly with globals.
For a new program, however, I plan to access the same global data through SQL-mapped classes.
I have two questions regarding this approach:
- If I define indexes in the SQL-mapped class, what potential impact (if any) could this have on the existing legacy application that directly accesses the globals?
- I’ve read that when an index is defined in an SQL class, it will not be automatically updated if data is modified directly in the global (outside of SQL