Re: Webobjects-dev Digest, Vol 2, Issue 2
Re: Webobjects-dev Digest, Vol 2, Issue 2
- Subject: Re: Webobjects-dev Digest, Vol 2, Issue 2
- From: Scott Keith <email@hidden>
- Date: Mon, 3 Jan 2005 15:20:20 -0500
Hi Nathan,
There actually has been a couple of cases where people wanted to
convert over their DBF files. My recommendation would be to first check
the archives at http://www.openbase.com/developer. I believe there was
a thread on this in there. You may also want to join the OpenBase Dev
list at http://www.openbase.com/lists in case you have further
questions.
If you are using the tabular import facility in the OpenBase Manager,
it is definitely slow. The reason is that it does some really complex
data integrity checking since it allows flat-data to be mapped to
multiple tables (automatically creating the relationships on import).
It does not work well on larger data sets because of the requirements
on the client side.
Since you have 2 million rows I would recommend either using the
import/export format that is available through openisql or check the
Dev list to see what the recommendations were. I think there was some
suggestion there that worked well that did not involve the tabular
import.
Please let us know how we can be of further service to you.
Best regards,
Scott Keith
OpenBase
On Jan 3, 2005, at 3:09 PM, email@hidden
wrote:
Message: 1
Date: Mon, 3 Jan 2005 02:53:45 -0500
From: Clint Fleetwood <email@hidden>
Subject: Legacy .dbf DOS system to WebObjects...
To: email@hidden
Message-ID: <email@hidden>
Content-Type: text/plain; charset=US-ASCII; format=flowed
We are in the process of doing a complete rehaul for a major shoe
company
of their entire
computer system including inventory control, point of sale, etc. We are
using WebObjects to do it and hopefully an OpenBase database.
They currently use a .dbf database for everything (many .dbf files) and
have custom
.exe files that control everthing through DOS (VERY ANCIENT !...) My
question is this:
Has anybody out there faced this similar situation and does anybody
have
any advice as to
dealing with this the proper way. His current InventoryMaster.dbf file
(the main database file) contains over 2 million records ! and is very
inefficient. It took 5 hours to import into OpenBase after exporting
the
.dbf to a Tab Delimited file. In the short term, while we convert his
system to something much more modern (probably take us a year - the DOS
programmer put 6 years into it and has created quite a BEAST), he needs
to
be able to push data to an eCommerce group (a company who put together
an
eCommerce site for them) constantly, the InventoryMaster.dbf file
changes
everyday. Anybody have any angles or point of views on tackling this
Monster ! ???
Anything would be greatly appreciated....Thanks,
-Nathan
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden