Progress to SQL Cost?

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?*



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]
Has anyone transitioned from Progress to SQL?
Is there a cost involved? Besides buying SQL Server which we already have?

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?*


[Non-text portions of this message have been removed]
Generally there are the costs of the new installation unless you do it
yourself, but there is also the cost of paying Epicor to do the conversion
from Progress to SQL, not sure how much they charge nowadays for that,
although there are some other companies who do that as well.


Ned

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Jose Gomez
Sent: Tuesday, March 15, 2011 1:03 PM
To: Vantage
Subject: [Vantage] Progress to SQL Cost?

Has anyone transitioned from Progress to SQL?
Is there a cost involved? Besides buying SQL Server which we already have?

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?*


[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
Assuming you have a Progress database already, you'll have to pay Epicor
to get that converted to MSSQL. For us, that conversion will take a
couple of days, so you might have scheduling issues for that.



Brian.



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Jose Gomez
Sent: Tuesday, March 15, 2011 1:03 PM
To: Vantage
Subject: [Vantage] Progress to SQL Cost?





Has anyone transitioned from Progress to SQL?
Is there a cost involved? Besides buying SQL Server which we already
have?

THanks!

*Jose C Gomez*
*Software Engineer*
*
*T: 904.469.1524 mobile
E: jose@... <mailto:jose%40josecgomez.com>
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?*





[Non-text portions of this message have been removed]
Can we just convert it ourselves?
Not to brag, but we're pretty handy with this Epicor stuff.

On Tue, Mar 15, 2011 at 1:13 PM, Brian Roberts <broberts@...> wrote:

>
>
> Assuming you have a Progress database already, you'll have to pay Epicor
> to get that converted to MSSQL. For us, that conversion will take a
> couple of days, so you might have scheduling issues for that.
>
> Brian.
>
> ________________________________
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of Jose Gomez
> Sent: Tuesday, March 15, 2011 1:03 PM
> To: Vantage
> Subject: [Vantage] Progress to SQL Cost?
>
> Has anyone transitioned from Progress to SQL?
> Is there a cost involved? Besides buying SQL Server which we already
> have?
>
> THanks!
>
> *Jose C Gomez*
> *Software Engineer*
> *
> *T: 904.469.1524 mobile
> E: jose@... <mailto:jose%40josecgomez.com>
> 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?*
>
> [Non-text portions of this message have been removed]
>
>
>


[Non-text portions of this message have been removed]
If you go for it yourself set it up in a test environment first and run through it there and nail the process down.

As for additional cost, the server requirement (mainly RAM) for MSSQL seems to be a lot steeper than if you stay with progress.

"Zac" Jason Woodward
Network Administrator
Intermountain Electronics, Inc.
O: 877-544-2291
M: 435-820-6515
F: 435-637-9601
www.ie-corp.com

Creating customer confidence through extraordinary service and experienced industry experts.


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Waffqle
Sent: Tuesday, March 15, 2011 11:16 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Progress to SQL Cost?

Can we just convert it ourselves?
Not to brag, but we're pretty handy with this Epicor stuff.

On Tue, Mar 15, 2011 at 1:13 PM, Brian Roberts <broberts@...> wrote:

>
>
> Assuming you have a Progress database already, you'll have to pay Epicor
> to get that converted to MSSQL. For us, that conversion will take a
> couple of days, so you might have scheduling issues for that.
>
> Brian.
>
> ________________________________
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of Jose Gomez
> Sent: Tuesday, March 15, 2011 1:03 PM
> To: Vantage
> Subject: [Vantage] Progress to SQL Cost?
>
> Has anyone transitioned from Progress to SQL?
> Is there a cost involved? Besides buying SQL Server which we already
> have?
>
> THanks!
>
> *Jose C Gomez*
> *Software Engineer*
> *
> *T: 904.469.1524 mobile
> E: jose@... <mailto:jose%40josecgomez.com>
> 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?*
>
> [Non-text portions of this message have been removed]
>
>
>


[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
No idea. I'd suggest setting up a test server, installing Epicor SQL
(it involves a read only progress schema database & the real SQL
database) and trying your database conversion.

We're upgrading from 6.1 to 9.05, and choose to spend our time dealing
with training & converting all our customizations etc, so decided to pay
for all the one-time conversion events.

Brian.


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Waffqle
Sent: Tuesday, March 15, 2011 1:16 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Progress to SQL Cost?

Can we just convert it ourselves?
Not to brag, but we're pretty handy with this Epicor stuff.

On Tue, Mar 15, 2011 at 1:13 PM, Brian Roberts <broberts@...>
wrote:

>
>
> Assuming you have a Progress database already, you'll have to pay
Epicor
> to get that converted to MSSQL. For us, that conversion will take a
> couple of days, so you might have scheduling issues for that.
>
> Brian.
>
> ________________________________
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf
> Of Jose Gomez
> Sent: Tuesday, March 15, 2011 1:03 PM
> To: Vantage
> Subject: [Vantage] Progress to SQL Cost?
>
> Has anyone transitioned from Progress to SQL?
> Is there a cost involved? Besides buying SQL Server which we already
> have?
>
> THanks!
>
> *Jose C Gomez*
> *Software Engineer*
> *
> *T: 904.469.1524 mobile
> E: jose@... <mailto:jose%40josecgomez.com>
> 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?*
>
> [Non-text portions of this message have been removed]
>
>
>


[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
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.
Thanks all!

*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:32 PM, Brian Roberts <broberts@...> wrote:

>
>
> No idea. I'd suggest setting up a test server, installing Epicor SQL
> (it involves a read only progress schema database & the real SQL
> database) and trying your database conversion.
>
> We're upgrading from 6.1 to 9.05, and choose to spend our time dealing
> with training & converting all our customizations etc, so decided to pay
> for all the one-time conversion events.
>
> Brian.
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of Waffqle
> Sent: Tuesday, March 15, 2011 1:16 PM
> To: vantage@yahoogroups.com
> Subject: Re: [Vantage] Progress to SQL Cost?
>
> Can we just convert it ourselves?
> Not to brag, but we're pretty handy with this Epicor stuff.
>
> On Tue, Mar 15, 2011 at 1:13 PM, Brian Roberts <broberts@...>
> wrote:
>
> >
> >
> > Assuming you have a Progress database already, you'll have to pay
> Epicor
> > to get that converted to MSSQL. For us, that conversion will take a
> > couple of days, so you might have scheduling issues for that.
> >
> > Brian.
> >
> > ________________________________
> >
> >
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> Behalf
> > Of Jose Gomez
> > Sent: Tuesday, March 15, 2011 1:03 PM
> > To: Vantage
> > Subject: [Vantage] Progress to SQL Cost?
> >
> > Has anyone transitioned from Progress to SQL?
> > Is there a cost involved? Besides buying SQL Server which we already
> > have?
> >
> > THanks!
> >
> > *Jose C Gomez*
> > *Software Engineer*
> > *
> > *T: 904.469.1524 mobile
> > E: jose@... <mailto:jose%40josecgomez.com>
> > 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?*
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
>
> [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]
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]
Have you considered including the COMPANY field in your table links to make use of the indexes?

I have found immense speed improvements in some ABL code when doing that....

$.02

--- In vantage@yahoogroups.com, Jose Gomez <jose@...> wrote:
>
> 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]
>
Yeah we actually did that on a newer version of the query it was slightly
faster but not significantly.

*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 2:01 PM, bw2868bond <bwalker@...>wrote:

>
>
> Have you considered including the COMPANY field in your table links to make
> use of the indexes?
>
> I have found immense speed improvements in some ABL code when doing
> that....
>
> $.02
>
>
> --- In vantage@yahoogroups.com, Jose Gomez <jose@...> wrote:
> >
> > 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]
> >
>
>
>


[Non-text portions of this message have been removed]
The only other thing that comes to mind is to maybe include fields or info to fully use the index where possible

for example (V8.03.405a) PartCost table, the Primary Index consists of Company, PartNum, CostID - we only have one CostID so maybe include the "AND PartCost.CostID = '1'" as part of the query

just thinking out loud......

--- In vantage@yahoogroups.com, Jose Gomez <jose@...> wrote:
>
> Yeah we actually did that on a newer version of the query it was slightly
> faster but not significantly.
>
> *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 2:01 PM, bw2868bond <bwalker@...>wrote:
>
> >
> >
> > Have you considered including the COMPANY field in your table links to make
> > use of the indexes?
> >
> > I have found immense speed improvements in some ABL code when doing
> > that....
> >
> > $.02
> >
> >
> > --- In vantage@yahoogroups.com, Jose Gomez <jose@> wrote:
> > >
> > > 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]
> > >
> >
> >
> >
>
>
> [Non-text portions of this message have been removed]
>
Having done it myself, it doesn't take a couple days, although that depends
on size of the DB and the speed of the server doing it, but somewhere
between 8 and 14 hours is about the normal time to get this done.

I think the biggest reason for doing it with Epicor is for safety sake and
having a them to fall back on as backup.

If the only reason to go to SQL is to assist with reporting which seems to
be the most common reason, I would look into the replication server for that
instead.

I don't see going to SQL as a response to speed being slow or slower than
desired.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Brian Roberts
Sent: Tuesday, March 15, 2011 1:13 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Progress to SQL Cost?

Assuming you have a Progress database already, you'll have to pay Epicor to
get that converted to MSSQL. For us, that conversion will take a couple of
days, so you might have scheduling issues for that.



Brian.



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Jose Gomez
Sent: Tuesday, March 15, 2011 1:03 PM
To: Vantage
Subject: [Vantage] Progress to SQL Cost?





Has anyone transitioned from Progress to SQL?
Is there a cost involved? Besides buying SQL Server which we already have?

THanks!

*Jose C Gomez*
*Software Engineer*
*
*T: 904.469.1524 mobile
E: jose@... <mailto:jose%40josecgomez.com>
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?*





[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
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