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.

Reply via email to