Hey Guys,
I am getting a lot of these errors today:
Transaction (Process ID 65) was deadlocked on lock | communication buffer
resources with another process and has been chosen as the deadlock victim.
Rerun the transaction.
On a system that is used to track 'views' of a page via an ajax
Index on sessionid will help immensely with that many rows.
Ultimately, I would suggest never using a Guid as a primary key,
performance is going to be less than ideal, even with an index.
Byron Mann
Lead Engineer Architect
HostMySite.com
On Jul 16, 2013 1:02 PM, Brook Davies
Absolutely you should have an index on sessionID. Without that index you
are forcing a table scan for that id so the engine can do the update. When
your table was smaller, SQL could deal with that a lot easier. Once you
start getting to 3-4 million rows, the performance starts to slow down
Thanks Jeff and Byron!
-Original Message-
From: Jeff Garza [mailto:j...@garzasixpack.com]
Sent: July-16-13 10:38 AM
To: cf-talk
Subject: re: Getting lots of DB Errors: Transaction was deadlocked on lock |
communication buffer resources with another process and has been chosen as
the
Hi. Submitting a in a text field to a webservice is causing the
webservice to throw an error. Should I be using:
amp;
or just:
urlencodedformat()
or something else?
--
John Bliss - http://about.me/jbliss
~|
Order the
Hi. Submitting a in a text field to a webservice is causing the
webservice to throw an error. Should I be using:
amp;
or just:
urlencodedformat()
I suggest xmlFormat().
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
http://training.figleaf.com/
Fig Leaf Software is a
Lord. Easiest Answer Of The Year entry. Thanks.
On Jul 16, 2013 5:40 PM, Dave Watts dwa...@figleaf.com wrote:
Hi. Submitting a in a text field to a webservice is causing the
webservice to throw an error. Should I be using:
amp;
or just:
urlencodedformat()
I suggest
7 matches
Mail list logo