split database queries slow fyi

[survivo01]

This may seem like a duh moment. I realized that I had been compacting my FE but never my BE. When I compaced it the MB went from 5 to 1. I guess I was not very bright. Just in case someone think like me. Speed of a report wnt form minutes to seconds.

[vincent-leeway]

Absolutely, I have even compacted my 6 lines of ASP code into a SQL query and speed of my software increased by manifolds. Learning to use subqueries, correlated queries and procedural programming could be a great help.