VISIT and VISITOR Entities

All, We have a LIVE application in which the VISIT AND VISITOR entities have grown to over 19 and 18 million rows respectively. Has anyone experienced any performance issues when these entities have grown to such capacity? We recently had a performance issue and decided to turn off the

Re: VISIT and VISITOR Entities

AND VISITOR entities have grown to over 19 and 18 million rows respectively. Has anyone experienced any performance issues when these entities have grown to such capacity? We recently had a performance issue and decided to turn off the visit history feature until this feature can be ruled out as

RE: VISIT and VISITOR Entities

ov 24, 2015 at 7:48 AM, Len Shein wrote: > All, > > We have a LIVE application in which the VISIT AND VISITOR entities > have grown to over 19 and 18 million rows respectively. > > Has anyone experienced any performance issues when these entities have > grown to such capacit

Re: VISIT and VISITOR Entities

AM, Len Shein wrote: > All, > > We have a LIVE application in which the VISIT AND VISITOR entities have > grown to over 19 and 18 million rows respectively. > > Has anyone experienced any performance issues when these entities have > grown > to such capacity? > > >

RE: VISIT and VISITOR Entities

t: Tuesday, November 24, 2015 11:13 AM To: user@ofbiz.apache.org Subject: Re: VISIT and VISITOR Entities Did the setting change improve performance? You could write a service that deletes data older than xxx days, then make it a scheduled job. Adrian Crum Sandglass Software www.sandglass-software.

Re: VISIT and VISITOR Entities

y, November 24, 2015 11:13 AM To: user@ofbiz.apache.org Subject: Re: VISIT and VISITOR Entities Did the setting change improve performance? You could write a service that deletes data older than xxx days, then make it a scheduled job. Adrian Crum Sandglass Software www.sandglass-software.com On 1

RE: VISIT and VISITOR Entities

Nick -Original Message- From: Adrian Crum [mailto:adrian.c...@sandglass-software.com] Sent: Tuesday, November 24, 2015 11:58 AM To: user@ofbiz.apache.org Subject: Re: VISIT and VISITOR Entities Hmmm... it could be the job scheduler. It was refactored a few years ago to fix problems like t

Re: VISIT and VISITOR Entities

ing up in the OFBiz Cache maintenance page. > Nick > > -Original Message- > From: Mike [mailto:mz4whee...@gmail.com] > Sent: Tuesday, November 24, 2015 11:31 AM > To: user > Subject: Re: VISIT and VISITOR Entities > > Most likely this table is stealing cache memory f

RE: VISIT and VISITOR Entities

Got it, thanks Mike. Nick -Original Message- From: Mike [mailto:mz4whee...@gmail.com] Sent: Tuesday, November 24, 2015 12:23 PM To: user Subject: Re: VISIT and VISITOR Entities > at least not OFBiz cache since I didn't mean the ofbiz cache. I meant the database (mysql/

Re: VISIT and VISITOR Entities

, 2015 12:23 PM To: user Subject: Re: VISIT and VISITOR Entities at least not OFBiz cache since I didn't mean the ofbiz cache. I meant the database (mysql/postgres) cache settings. On Tue, Nov 24, 2015 at 8:34 AM, Nick Rosser wrote: Thanks Mike -- don't think this is a cache is

Re: VISIT and VISITOR Entities

Thanks Mike -- don't think this is a cache issue -- at least not OFBiz >> cache since it is not showing up in the OFBiz Cache maintenance page. >> Nick >> >> -Original Message- >> From: Mike [mailto:mz4whee...@gmail.com] >> Sent: Tuesday, Novemb