Project Detail

database timing out when we delete records  

database timing out when we delete records is project number 283798
posted at Freelancer.com. Click here to post your own project.

 

| More Free Trial For New Buyers
 

Status:

Selected Providers: expertMan

Budget: $30-250

Created: 07/07/2008 at 10:16 EDT

Bid Count: 7

Average Bid:
N/A

07/08/2008 at 10:16 EDT

Project Creator: BeanozTec
Employer Rating: 10/1010/1010/1010/1010/1010/1010/1010/1010/1010/10 (49 reviews)

Bid On This Project
 

Description

We need a solution to a problem deleting records from a large SQL Server database. It is a database with logs of hits on 50 or 60 websites for each day over a period of 9 months. We need to delete old records because the database is getting too big and too slow to run queries. It is very slow deleting the records from the database because for example if you write,
"delete from tracking where accessdate <='2007/07/31'"

it will timeout and you have to delete one day at a time. We need to see why this is happening and be able to delete a whole month without it timing out.

Messages Posted:0 View project clarification board Post message on project clarification board

Bid On This Project
 

If you are the project creator or one of the bidders Log In for more options

Bids are hidden by the project creator. Log in as the project creator or as one of the bidders to view bids. You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


    Bid on this Project