Thanks Kevin we will give that a shot in the future. Anyone up for
re-writing this thing properly? hahah
*Jose C Gomez*
*Software Engineer*
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
*Quis custodiet ipsos custodes?*
re-writing this thing properly? hahah
*Jose C Gomez*
*Software Engineer*
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
*Quis custodiet ipsos custodes?*
On Tue, Mar 15, 2011 at 4:34 PM, Kevin Simon <ksimon@...> wrote:
>
>
> Jose,
>
> Regarding the 24 hours to run an update, that seems to be not too out of
> the
> ordinary.
>
> One thing I've found is that it's a lot faster to run a lot of smaller
> updates than one large update. In other words, I would be if you took those
> 84000 parts and ran them in groups of 2000, it would take a lot less to
> update. I'm not sure if there's some type of rollback buffer that it's not
> clearing.
>
> Kevin
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of
> Jose Gomez
> Sent: Tuesday, March 15, 2011 1:55 PM
> To: vantage@yahoogroups.com
> Subject: Re: [Vantage] Progress to SQL Cost?
>
> Mark,
> Just curious we are pretty handy with the darn thing, but the one aspect of
> Epicor we haven't been able to nail down, is the speed issue. Sure it runs
> ok enough but compared to almost any product in the market its really slow.
>
> Add to that the thousands of lines of customization and integration and
> well, some modules take for ever! We have moved most of our code to BPM's
> and such in order to take the burden off the client but that has only
> helped slightly.
>
> Most recently we ran a query (ABL) to update 1 field on our parts
> table and it literally took us 24 hours to run the darn thing. It just
> seems
> like this can't be the normal behavior of a DB. Sure we have 84 000 parts
> but 24 hours seems like way too long.
>
> We are just trying to gauge if SQL would do any better. I know that we
> would
> still run through a progress schema and all that stuff, but we are just
> curious. If you have any insight on this I'd love to hear it.
>
> BTW we are running on Dedicated SSD's with a nice RAID configuration (As
> suggested by some of he better Progress PPL at Epicor)
>
> I've also uploaded the mentioned Query to the group under "ABL Query for
> the
> Curious"
>
> Thanks
>
> *Jose C Gomez*
> *Software Engineer*
> *
> *T: 904.469.1524 mobile
> E: jose@...
> http://www.josecgomez.com
> <http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez
> >
> <http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
> <http://www.josecgomez.com/professional-resume/>
> <http://www.josecgomez.com/feed/>
>
> *Quis custodiet ipsos custodes?*
>
>
> On Tue, Mar 15, 2011 at 1:42 PM, Mark Wonsil <mark_wonsil@...>
> wrote:
>
> >
> >
> > Jose asks:
> >
> > > Has anyone transitioned from Progress to SQL?
> > > Is there a cost involved? Besides buying SQL Server which we already
> > have?
> >
> > The question is why do you want to move? If it's reporting only, I'd
> > probably invest in the Replication Server and report from the SQL
> > Server. It will give you better performance than reporting from your
> > live server.
> >
> > If it's for easier updates to the database, I only use business
> > objects so the underlying database doesn't matter.
> >
> > Just wondering...
> >
> > Mark W.
> >
> >
> >
>
> [Non-text portions of this message have been removed]
>
> ------------------------------------
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
> already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder and
> Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
>
>
>
[Non-text portions of this message have been removed]