Hi Dominik,
This is an off the cuff comment, I haven't done any formal study of it or
anything.
I would pay close attention to your field layouts. If the database is
750GB, it might be larger or smaller than that with SAPDB. I would map each
field to the underlying datatype and compare the overall record sizes.
I found that when migrating from the Microsoft products, the
datetime/timestamp fields were much larger in SAPDB. I also found that I
had to create combined indexes (field1,field2) where the Microsoft tools
could often use individual indexes and combine them as needed. For one
application, I had to create twice as many indexes after moving to SAPDB.
SAPDB also uses CHAR internally for all VARCHAR fields, it is possible
another system may optimize storage for VARCHAR.
At least when coming from very "lean" products like MySQL and Access MDB
files, I would not be surprised to see a 1.2 to 2.0 increase in overall
space requirements. Of course, this depends on the record layout.
I have not worked with Oracle, I do not know of space-conscious it is
internally...
Regardless, I would encourage you to take the time to estimate how your
records will map from Oracle --> SAPDB to make sure your 750GB doesn't come
out to 1.2GB and change your system planning requirements.
Stephen Gutknecht
currently in Lake Havasu City, Arizona, USA
- 100 degrees F today :)
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 12, 2002 6:39 AM
To: [EMAIL PROTECTED]
Subject: Experience on linux/sapdb with VLDB (750 GIG)?
Hi,
we are planing to do an OS/DB migration of an 4.0B Retail system with Oracle
8.0.4./SunOS to linux/sapdb. Does anybody have experience on sapdb and very
large databases. Can sapdb still handle 750 GIG or is it to large ?How about
the resources needed to handle an sapdb with linux of that size, any
experiences ?
Thank you for your help
Dominik Sobolewski
Gambit Consulting GmbH
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
