Jeff,
Is there any way that you can detect a phantom record as soon as it's
been added? If you could do a check for a blank or null order number as
soon as a save is done and then add some code in to dump out a stack
trace and anything else that might be helpful?
If that won't work, maybe you can add a trigger on the table to not save
records with blank/empty/null order number?
Every field being indexed on shouldn't really be a problem except for
maybe slowing things down. Entering slashes in a memo field should not
be a problem either unless there is some special code running when it
detects a slash.
Frank.
Frank Cazabon
On 22/02/2013 12:39 PM, Jeff Johnson wrote:
The slashes in the memo fields are user entered. They enter a date
"06/25/2012" would cause phantom orders to start. There is really
strong evidence of this. So when they write a record every field is
included in the CDX and there are several memo fields and they are
doing an append blank / gather with about 50 users.
The system will then generate from two to 50 phantom orders until an
valid record is appended and gathered and it stops.
This also happens when there is high user traffic.
It really sounds like this is what it is but it would be nice to be
certain before proceeding.
I have a test server. Maybe I can simulate adding a whole bunch of
records programatically and try to duplicate it.
Thanks,
Jeff/
---------------
Jeff Johnson
[email protected]
(623) 582-0323
www.san-dc.com
www.arelationshipmanager.com
On 02/22/2013 08:44 AM, Kurt wrote:
Ok- good to know the code isn't too bad.
So - curious thing - maybe the Move to Virtual Server is Directly
related to
your current problem.
As for gathering a Slash into a Memo field impacting speed - I really
can't
comment on that. So - is this slash in the Memo field actually
Intentional???
-K-
-----Original Message-----
From: ProfoxTech [mailto:[email protected]] On Behalf Of Jeff
Johnson
Sent: Friday, February 22, 2013 10:40 AM
The code isn't really too bad. The programmers son did the code I sent
you. They also went from a physical server to a virtual server at about
this time. So it really points to timing. Is there any chance that
gathering memo fields with slashes in them could be even a tiny bit
slower than memo fields without them?
Jeff
---------------
[excessive quoting removed by server]
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[email protected]
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
