Re: Writing Activity Monitor

Jamshed wrote: 
Hello everyone,
I would like to know how or what approach one can use to write the
following typical application. Or perhaps there's already something
that can used with some modification.

I would appreciate your thoughts and inputs.

Quesiton:
What is best way to write the following app, i.e. should i used dynamic
pages in tclhttpd or use RSS or write standalone TK client application.

Scenario is:
Activity performance data is written to sql tables, this application
should grab the data and create summary and detail views for the
operators. Approxmately 50,000 rows will be queries to generate all
views.

Activity usually last for max 6 hours. During which each operators must
be able to track activities by refreshing their data views.

Such an application have two kinds of users one is Operator who monitor
the activity progress live. They want to know exact numbers and details
what is going on right that moment.

Another set of user is more managerial, who come in the morning and
would like to simply browse the results of the activities.


I have already tries this with tclhttpd/TCL Server Pages (customized
version by vendor, provides .tsp pages). But the performance is very
slow approximate 40 seconds wait for viewing summary views and more for
detail views. If you have 5 operators each refreshing different views
the response times gets much worse.

First thing you should check is how expensive is it for the Database to update your views etc. If the database takes 40 seconds to create your view data, you have to optimize your database or queries and not the display.

Depending on frequency of changes/updates and local setup a web page may be ok or a Tk app (or the Tk plugin, if you go for browser based), may provide a better solution.

Michael
.

Relevant Pages

  • Re: access 2003
    ... I would focus on the queries behind the combo boxes. ... the Access 97 database, I wouldn't have thought any expressions would be ... When you select a customer and a job in the two combo boxes, ...
    (microsoft.public.access.conversion)
  • Re: access 2003
    ... I would focus on the queries behind the combo boxes. ... the Access 97 database, I wouldn't have thought any expressions would be ... When you select a customer and a job in the two combo boxes, ...
    (microsoft.public.access.conversion)
  • Re: Question on conversion to ADP
    ... the money toward developping .NET technologies instead of Access. ... result of passthrough queries read/write instead of read only and also make ... database become corrupted when the users will start making their very own ... of ADP but what they are pushed toward is - how could I say that politely - ...
    (microsoft.public.access.adp.sqlserver)
  • Re: User has group permissions to object, but still denied access.
    ... permissions to those query objects. ... The owners for the other 68 queries can be changed. ... may have been some of the original queries created in the database. ... Regarding the security, the database was converted from an Access 97 ...
    (microsoft.public.access.security)
  • Re: Access/Word 2007 Mail Merge
    ... have thought that they would have occured earlier in the connection process. ... specify DDE, I always get the DDE dialog. ... might be "unusual" about your database, its location, etc. ... This isn't quite what I normally see either: Queries with joins are ...
    (microsoft.public.word.mailmerge.fields)