RE: Summary of large amounts of data

2002-11-11 Thread Adam Reynolds
How is your data structured? I'm assuming you are using Star Schemas and stored procedures to do most data retrieval and processing. Your CF front-end should do little if any data processing. -Original Message- From: JS [mailto:hoftalk;yahoo.com] Sent: 08 November 2002 16:07 To:

Re: Summary of large amounts of data

2002-11-08 Thread Paul Hastings
and cumbersome to deal with. What are some of you doing to solve this problem? The database is SQL Server 2000. no idea of your app logic but i normally use summary tables that get updated via triggers or scheduled jobs running sp depending how fresh or offensive the summaries need to be.