Best practice when using data from external files

Hi folks,

I'm looking for some advice on the best practice when using external files to contain data.

I work in a contact centre and have created a web based stats viewer for my team (it's very simple, just allows you to pick a date range and shows you your stats and the team average but also includes links to graphs with the data displayed). While this works great for my team, other Managers want me to create the same (which is going to cover another 20 teams).

My major concern is the size of the data file (the data starts from Jan 2004), so I thought about splitting the files by team but then realised there would be issues of Agents moving to other teams. I then looked at creating a separate file for every Agent but then became concerned about having 250+ files.

The script would be smaller if the data file was singular but as the data expands this could take quite a while to read. In addition, locking the file could delay others from using the script.

If I have individual data files for each Agent then this would speed up usage, but then the script would become more complex.

What would the best practice be in this case?

Cheers!
--
Dale

.

Relevant Pages

  • Re: Run SQL script on Instance Startup
    ... Run script on Instance Startup ... might feel better to have a client app (Agent) execute whatever TSQL ... might feel better to have a client app execute whatever TSQL commands you want to run ...
    (comp.databases.ms-sqlserver)
  • Re: OT: Umra posting statistics for May 2008
    ... rather than adding tabs (which can go all over the place if ... horror when I clicked on the "show formatting" button. ... language Jo's script is written in but something like C or Perl's ... always welcome :-) I'm just using Agent, ...
    (uk.media.radio.archers)
  • Re: Where does the Exchange 2000 Event Service get its session?
    ... I guess I should have mentioned this initially, I'm not using script ... but instead writing a custom agent. ... MAPILogon() I'm remoting the processing of the message which triggered the ... We therefore plan to stick with the Event Service. ...
    (microsoft.public.exchange.development)
  • Re: KDE ssh-agent
    ... I just meant that if you tweak the script and then it gets updated via ... My script checks for a preexisting agent, and if it finds one, it ... before the xinitrc-common script runs, you should be able to easily work ...
    (Fedora)
  • small script --> huge load --> error message
    ... I'm sure everybody who works with javascript has seen this ... A script on this page is causing mozilla to run slowly. ... way to tell a javascript to give control back to the agent interface ... var oTable, oTHead, oTBody, oTFoot, oCaption; ...
    (comp.lang.javascript)