large database

I have a customer with SQL 2005 workgroup edition. Their database is now growing about a half gig a month due to doing 3K transactions a day (very
busy store) The problem is when an end of month report is generated the registers freeze for the 5 minutes it takes to generate the report. Americans don't want to wait that long to get thier bottled water or candy bar.
The server for the store was upgraded to Server 2006 64-bit but not SQL 2005 64-bit as the 64 bit version of SQL won't run Microsoft RMS Does any one have any ideas to keep the registers from freezong. Dave of Superior POS
Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
If its one database feeding all the clients, your network and local processing are your bottlenecks - can you increase RAM and put in gigabit networking? You can also consider running your end of month report as a select query using SO administrator on the SQL server as opposed to the active report; or as part of end of month closing procedures, backup the database, and restore it on say a laptop, where you can run your end of month reports; or if you're not open 24 hrs., run the EOM report on the last day of the month after you've done your Z reports.
"Dave of Superior POS" wrote:

Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload

BeanSmart.com is a site by and for consumers of financial services and advice. We are not affiliated with any of the banks, financial services or software manufacturers discussed here. All logos and trade names are the property of their respective owners.

Tax and financial advice you come across on this site is freely given by your peers and professionals on their own time and out of the kindness of their hearts. We can guarantee neither accuracy of such advice nor its applicability for your situation. Simply put, you are fully responsible for the results of using information from this site in real life situations.