Which ones performance is better: a single complex query or multiple queries and process at code level?
Anonymous
It s depend on the configuration of the database server and Application Server. Best approach is to test both way and go for better one.
Check out your Company Bowl for anonymous work chats.