Queries perform slow with shortcuts

If you have questions or if you want to share your opinion about Aware IM post your message on this forum
Post Reply
[email protected]
Posts: 278
Joined: Tue Aug 05, 2008 3:16 pm

Queries perform slow with shortcuts

Post by [email protected] »

I have an Object that uses external database SQL objects. When I use a shortcut in an object and that shortcut is based off of an object that is an external object, I notice the performance of queries and other types of queries that reference the Object that has the shortcut is a lot slower. I realize that there will be a degredation to an external source, but not to the level I am seeing. Especially considering all of the AwareIM and my external sources exist on the same server SQL DB.

My current objects that are giving me difficulty:

Software (AwareIM native)
SLPurhcase (SQL view) (child to object Software)

Not sure if this all makes sense.
Post Reply