Find Jobs
Hire Freelancers

SQL SERVER trigger intersect bug

$2-8 USD / hour

Closed
Posted over 7 years ago

$2-8 USD / hour

I have a trigger which check if a points intersects with many polygons, there are 500 points and they are updated every 20 seconds, so we have mote than 1500 updates per minutes, so this trigger causes problem on my server giving an error like this: Exceptions Transaction (Process ID ) was deadlocked on lock resources with another process and has been chosen as the deadlock victim I think this is because trigger is triggered many times, more tan 20 times per second... so what can we do to improve this? PAying only 10 and 15 if you do a bonus, really simple
Project ID: 11036453

About the project

4 proposals
Remote project
Active 8 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
4 freelancers are bidding on average $6 USD/hour for this job
User Avatar
Hi there! I have read what you exactly need, however I would like to ask you a few questions. I wouldn't call myself a master but I do work smart and do not rest until I get the job done. Please feel free to ping me anytime so we can have a detailed discussion. If I can deliver I will deliver in best possible way.
$5 USD in 1 day
5.0 (4 reviews)
2.7
2.7
User Avatar
Please let me know more details and when will we start.
$4 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I am very familiar with the specific problem you are having. I will like to take a look at it and resolve it. Regards Yemisi O
$5 USD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of MEXICO
Mexico
4.7
32
Payment method verified
Member since Sep 17, 2013

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.