Smart Client Questions

[Fidget Brain]

hello there. i have been asked to develop a smart client application, and
the first task is to develop a reporting module. i've got a few questions
please.

1. i am concerned that outputting potentially large datasets of reporting
data via a web service might mean a big performance hit. am i right to be
concerned? if so, what steps can i consider to solve this problem?

2. if performance IS an issue then i have already considered caching the
data locally to prevent unnecessarily hitting the web service. however, this
is reporting data, so by nature it is changing frequently. the easiest
solution is to hit the web service every time. an alternative would be to
update a timestamp field for each report, updated via triggers, giving a
quick indication of whether the cached data was stale or not. however, as
the database contains hundreds of reports, many of which contain multiple
joins, this seems to be a nightmarish prospect to set up, and very error
prone. is this a common issue with smart client development? what steps
should i consider taking here?

 

[Fidget Brain]

thanks for your advice. it all makes sense to me.

"Buying the user small puzzles or sudoku books to keep them occupied while
they wait for their reports."

lol

By this, do I take you to mean that smart clients look good on paper, but in
practice run like a one legged horse?

 

[RobinS]

thanks for your advice. it all makes sense to me.

"Buying the user small puzzles or sudoku books to keep them occupied
while
they wait for their reports."

lol

By this, do I take you to mean that smart clients look good on paper,
but in practice run like a one legged horse?

Any application hitting a server for huge amounts of the data
will have the same problem. It doesn't matter if it's a
smart client, fat client, thin client, web service, etc.
It also depends a lot on the network being used to access
the data. At some companies I've worked for, the network
has been stellar and you could read/write thousands of records
without it being a problem, and at others, the same thing would
take days. >:-O

Robin S.