HI

We started doing allocations last year for 100 classrooms and it has slowed report running down considerably. Most reports take 5 minutes or so to run.  The larger summary reports in FE can take much longer.  The server is a dual Xeon with 4GB ram running 2003 standard and SQL 2000 and our db is almost 3GB.  What can I do to improve report speed other than the maintance console?

Thanks for your suggestions

Maureen