F
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?
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?