Application variables

[sde]

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?

[Belisarius]

When getting the issues from the database, why don't you simply cross the query with the agent table? Then when you create the Issue object (which I assume is an object), simply fill in the agent's name?

[sde]

my issue class and agent class are seperate, . then i have an issue db class and an agent db class which handle their own db interaction to get their own info.

i was trying to keep it seperate, but i guess you're right, maybe i should break my strict enforcement of crossing classes for db queries.