Find Jobs
Hire Freelancers

database timing out when we delete records

$30-250 USD

进行中
已发布将近 16 年前

$30-250 USD

货到付款
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.
项目 ID: 283798

关于此项目

6提案
远程项目
活跃16 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作

关于客户

IRELAND的国旗
Dublin, Ireland
4.9
107
付款方式已验证
会员自12月 21, 2005起

客户认证

谢谢!我们已通过电子邮件向您发送了索取免费积分的链接。
发送电子邮件时出现问题。请再试一次。
已注册用户 发布工作总数
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
加载预览
授予地理位置权限。
您的登录会话已过期而且您已经登出,请再次登录。