Dump and load of database

Yahoo Archive
1
Just to give everyone with performance problems a heads up. When we went to
Vantage 5.2 last year we noticed some performance problems in customer
tracker, AP invoice entry plus the new engineering workbench was painfully
slow. We assumed it was the new version and our old server and went on with
life.

Recently we had Vantage support look at our database and they said it was
fragmented and we needed to do a "dump and load" of the database. They sent
us a kit to do this. We just completed it over the weekend and have seen an
incredible performance increase. The new database is the 8K block size
instead of the 4K block size. This allows for the use of files larger than
2GB, so now we don't have the multi-extents...just one big 4GB file for the
data.

With the performance increase that we have seen it was worth being up here
all weekend and I would suggest it to anyone with speed problems in Vantage
5.2

FYI

Paul Lipham


[Non-text portions of this message have been removed]
2
Does anyone know if there is a way to disable the minimum password length on
a Win 2003 Domain Controller? TIA

Nancy Schultz
GTR Manufacturing Corp.
Tel: 508-588-3240
Fax: 508-583-7361

[Non-text portions of this message have been removed]
3
On 2003 server if you go to "programs" then "administrative tools" and look
for "domain controller security policy" in there you will see account policy
and under that password policy. After making the change you have to either
restart or issue some stupid command line. I can't remember the command
line to kick it in, but a restart will do it.

Paul Lipham
Alabama Specialty Products, Inc.
-----Original Message-----
From: Nancy Schultz [mailto:nschultz@...]
Sent: Friday, July 23, 2004 11:13 AM
To: vantage@yahoogroups.com
Subject: [Vantage] OT: Disable Min PW Length


Does anyone know if there is a way to disable the minimum password length
on
a Win 2003 Domain Controller? TIA

Nancy Schultz
GTR Manufacturing Corp.
Tel: 508-588-3240
Fax: 508-583-7361

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


Yahoo! Groups Sponsor
ADVERTISEMENT





----------------------------------------------------------------------------
--
Yahoo! Groups Links

a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/

b.. To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com

c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



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