If you have questions or if you want to share your opinion about Aware IM post your message on this forum
#52241 by ddumas
Tue Dec 03, 2019 1:37 pm
I have an Event Business Object (BO) that has basic attributes like Date, EventType, Topic, Status, Organizer, and Attendees (another related BO).

Depending on the EventType, I will have other attributes that are specific to an EventType. Is it better design (flexibility, but more important, performance) to have separate groups of attributes in a single Event BO, or better to store those EventType specific attributes in separate related BOs? If separate related BOs, those would be peers to the Event BO.

For example, a conference event would have separate attributes than a meeting event. Hopefully I have described this well.

Dave
#52253 by aware_support
Tue Dec 03, 2019 10:49 pm
Hard to say. Design-wise groups of objects are better. However, groups of objects incur some performance penalty when you include business object groups in your queries. Whether this penalty will be significant depends on the queries and how they are used in the system. Some poorly performing queries can be replaced with stored procedures, though.
#52256 by ddumas
Wed Dec 04, 2019 10:43 am
Thanks. as a database guy, I will look to using AwareIM with stored procedures. I did not see a video on that, but I will look through the doc.

On that note of stored procs, I see that a BASEVERSION is implemented in the tables. I assume that gets overwritten by the app as necessary, and AwareIM is not creating separate "versioned" records, correct? I would not want to worry about versioning when searching for database records in stored procs.

Dave
#52267 by aware_support
Wed Dec 04, 2019 10:03 pm
Code: Select allI did not see a video on that, but I will look through the doc.

You need to look up the EXEC_SP action, which can be used both in queries and in business rules.
Also EXEC_SPF function.

Code: Select allOn that note of stored procs, I see that a BASEVERSION is implemented in the tables. I assume that gets overwritten by the app as necessary, and AwareIM is not creating separate "versioned" records, correct? I would not want to worry about versioning when searching for database records in stored procs.

Correct

Who is online

Users browsing this forum: rbross and 21 guests