SLOW 4to5 Conversion Idxbuild

Yahoo Archive
1
Regarding the pagefile.sys; don't copy it, use performance options in
Control Panel (system/advanced/performance options/Change/Virtual Memory).
After reading my repy, I am afraid someone could have taken it the wrong
way.....

Paul

-----Original Message-----
From: Paul Siebers
Sent: Tuesday, December 18, 2001 5:36 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [VANTAGE] SLOW 4to5 Conversion Idxbuild


Norm,

I used 2 workstations with w2k and a lesser config than your setup and it
was pretty fast. A few things to keep in mind:
-I don't know the size of your db, mine was only 550 Mb.
-New Server: make sure the manufacturer isn't playing tricks on you: case in
point: All recent Dell stuff seems to come with a preinstalled mfg
partition loaded with their proprietary stuff rip this out at your
discretion. After deleting those my hardware really flies.
-Then I found significant improvements after relocating the pagefile.sys
from the drive on which Vantage will be running (maybe you have one of those
laying around).
-Are all your groups posted?

Just a few things to check to get you started.

Paul

-----Original Message-----
From: nwatkins [mailto:nwatkins@...]
Sent: Tuesday, December 18, 2001 4:23 PM
To: vantage@yahoogroups.com
Subject: [VANTAGE] SLOW 4to5 Conversion Idxbuild


I know slow conversions have been a topic for a while, but I think my
problem doesn't seem to fit it with the other discussions.

I'm trying to bring up a new server and convert from 4.0 to 5.0 at the same
time, but seem to be having problems with slow indexing and other
conversions.

Server config: P4, 1 ghz processor, 1 gig RAM, OS: W2K Server. No virus
protection installed yet. No other software installed. 2 fast scuzi drives
(mirroring of both C (OS) and D (Vantage)

For a variety of reasons (1 being the server crashed 1 time) I have restored
the 4.0 data base from a backup several times, and performed all the
associated operations necessary to upgrade. Reindexing the restored
database takes several hours (left it run overnight - figured it took about
6+ hours based on time to complete group 6, phase 2). Epicor tech support
says it is my server setup, and idxbuild should take < 30 minutes.

If anybody can help with my server setup, I would appreciate either a
response here/offline/phone call (please call before 3:30 P.M. CST).

Thanks in advance for any help!

Norm Watkins
ELECPAC
800-639-2307



Yahoo! Groups Sponsor

ADVERTISEMENT

<
http://rd.yahoo.com/M=178320.1681224.3270152.1261774/D=egroupweb/S=17050071
<http://rd.yahoo.com/M=178320.1681224.3270152.1261774/D=egroupweb/S=17050071
>
83:HM/A=879172/R=0/* http://www.fastweb.com/ib/yahoo-75f
<http://www.fastweb.com/ib/yahoo-75f> >

<
http://us.adserver.yahoo.com/l?M=178320.1681224.3270152.1261774/D=egroupmai
<http://us.adserver.yahoo.com/l?M=178320.1681224.3270152.1261774/D=egroupmai
>
l/S=1705007183:HM/A=879172/rand=742041643>

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/.
<http://groups.yahoo.com/group/vantage/files/.>
< http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/.> >
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
< http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages> >
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links>
< http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links> >

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
< http://docs.yahoo.com/info/terms/ <http://docs.yahoo.com/info/terms/> > .




[Non-text portions of this message have been removed]



Yahoo! Groups Sponsor

ADVERTISEMENT

<http://rd.yahoo.com/M=178320.1681224.3270152.1261774/D=egroupweb/S=17050071
83:HM/A=879173/R=0/*http://www.fastweb.com/ib/yahoo-76f>

<http://us.adserver.yahoo.com/l?M=178320.1681224.3270152.1261774/D=egroupmai
l/S=1705007183:HM/A=879173/rand=817183514>

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/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links>

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]
2
I know slow conversions have been a topic for a while, but I think my
problem doesn't seem to fit it with the other discussions.

I'm trying to bring up a new server and convert from 4.0 to 5.0 at the same
time, but seem to be having problems with slow indexing and other
conversions.

Server config: P4, 1 ghz processor, 1 gig RAM, OS: W2K Server. No virus
protection installed yet. No other software installed. 2 fast scuzi drives
(mirroring of both C (OS) and D (Vantage)

For a variety of reasons (1 being the server crashed 1 time) I have restored
the 4.0 data base from a backup several times, and performed all the
associated operations necessary to upgrade. Reindexing the restored
database takes several hours (left it run overnight - figured it took about
6+ hours based on time to complete group 6, phase 2). Epicor tech support
says it is my server setup, and idxbuild should take < 30 minutes.

If anybody can help with my server setup, I would appreciate either a
response here/offline/phone call (please call before 3:30 P.M. CST).

Thanks in advance for any help!

Norm Watkins
ELECPAC
800-639-2307
3
Tune your new 4.0 database before you reindex by bumping up the -b
parameter. Epicor has a document on this. When I went to 4.0 I documented a
big increase in speed here.

Patrick Winter

-----Original Message-----
From: nwatkins [mailto:nwatkins@...]
Sent: Tuesday, December 18, 2001 3:23 PM
To: vantage@yahoogroups.com
Subject: [VANTAGE] SLOW 4to5 Conversion Idxbuild


I know slow conversions have been a topic for a while, but I think my
problem doesn't seem to fit it with the other discussions.

I'm trying to bring up a new server and convert from 4.0 to 5.0 at the same
time, but seem to be having problems with slow indexing and other
conversions.

Server config: P4, 1 ghz processor, 1 gig RAM, OS: W2K Server. No virus
protection installed yet. No other software installed. 2 fast scuzi drives
(mirroring of both C (OS) and D (Vantage)

For a variety of reasons (1 being the server crashed 1 time) I have restored
the 4.0 data base from a backup several times, and performed all the
associated operations necessary to upgrade. Reindexing the restored
database takes several hours (left it run overnight - figured it took about
6+ hours based on time to complete group 6, phase 2). Epicor tech support
says it is my server setup, and idxbuild should take < 30 minutes.

If anybody can help with my server setup, I would appreciate either a
response here/offline/phone call (please call before 3:30 P.M. CST).

Thanks in advance for any help!

Norm Watkins
ELECPAC
800-639-2307



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/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
4
Norm,

I used 2 workstations with w2k and a lesser config than your setup and it
was pretty fast. A few things to keep in mind:
-I don't know the size of your db, mine was only 550 Mb.
-New Server: make sure the manufacturer isn't playing tricks on you: case in
point: All recent Dell stuff seems to come with a preinstalled mfg
partition loaded with their proprietary stuff rip this out at your
discretion. After deleting those my hardware really flies.
-Then I found significant improvements after relocating the pagefile.sys
from the drive on which Vantage will be running (maybe you have one of those
laying around).
-Are all your groups posted?

Just a few things to check to get you started.

Paul

-----Original Message-----
From: nwatkins [mailto:nwatkins@...]
Sent: Tuesday, December 18, 2001 4:23 PM
To: vantage@yahoogroups.com
Subject: [VANTAGE] SLOW 4to5 Conversion Idxbuild


I know slow conversions have been a topic for a while, but I think my
problem doesn't seem to fit it with the other discussions.

I'm trying to bring up a new server and convert from 4.0 to 5.0 at the same
time, but seem to be having problems with slow indexing and other
conversions.

Server config: P4, 1 ghz processor, 1 gig RAM, OS: W2K Server. No virus
protection installed yet. No other software installed. 2 fast scuzi drives
(mirroring of both C (OS) and D (Vantage)

For a variety of reasons (1 being the server crashed 1 time) I have restored
the 4.0 data base from a backup several times, and performed all the
associated operations necessary to upgrade. Reindexing the restored
database takes several hours (left it run overnight - figured it took about
6+ hours based on time to complete group 6, phase 2). Epicor tech support
says it is my server setup, and idxbuild should take < 30 minutes.

If anybody can help with my server setup, I would appreciate either a
response here/offline/phone call (please call before 3:30 P.M. CST).

Thanks in advance for any help!

Norm Watkins
ELECPAC
800-639-2307



Yahoo! Groups Sponsor

ADVERTISEMENT

<http://rd.yahoo.com/M=178320.1681224.3270152.1261774/D=egroupweb/S=17050071
83:HM/A=879172/R=0/*http://www.fastweb.com/ib/yahoo-75f>

<http://us.adserver.yahoo.com/l?M=178320.1681224.3270152.1261774/D=egroupmai
l/S=1705007183:HM/A=879172/rand=742041643>

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/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links>

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]