|
|
Posted by Doug on 04/06/06 20:04
What Alexander said.
Large views work for a bit for some customers. Eventually the
customer's needs will start to expand, the data will expand, and the
larger views will start to fade in satisfaction. Performance slows
down, your customers will need more detailed data, and in general the
views will reach their limits.
You can often buy yourself a little time by upgrading hardware on the
server and client, and buy yourself more time by moving towards stored
procedures.
In the bigger picture, your application is successful. It is storing
the needed data, and your customers are learning what is available, and
using that data to solve business needs.
The next step up the staircase is an OLAP solution. It is a fairly big
step, but it is very powerful, and will solve many of your power users
needs.
Navigation:
[Reply to this message]
|