Code Forums - View Single Post

sde · 09-01-2004, 05:13 PM

I am really trying to use as little data queries as possible on this project because I want to make this app as fast as it can be.

i have about 20 users who use this application. they are a class 'agent'

my app gets issues from the issue table which has an agent id.

let's say i have an array of issues, .. if i want to display the username of the agent who was on the issues as i loop through them, i need to make another query for each issue.

is it possible to setup an application level variable that stores an array of my agents? then i could get their id by using their id as the array key.

agent[issue.getAgentID()]['username']

or something like that. i was thinking this or just adding another field in the issue table that stores the username. i didn't want to do this as it is not the best practice for a relational database.

any thoughts on this?

09-01-2004, 05:13 PM	#1 (permalink)
sde Moderator Join Date: May 2002 Location: us.ca Posts: 4,532	Application variables I am really trying to use as little data queries as possible on this project because I want to make this app as fast as it can be. i have about 20 users who use this application. they are a class 'agent' my app gets issues from the issue table which has an agent id. let's say i have an array of issues, .. if i want to display the username of the agent who was on the issues as i loop through them, i need to make another query for each issue. is it possible to setup an application level variable that stores an array of my agents? then i could get their id by using their id as the array key. agent[issue.getAgentID()]['username'] or something like that. i was thinking this or just adding another field in the issue table that stores the username. i didn't want to do this as it is not the best practice for a relational database. any thoughts on this? __________________ Mike