Re: Legacy .dbf DOS system to WebObjects...
Re: Legacy .dbf DOS system to WebObjects...
- Subject: Re: Legacy .dbf DOS system to WebObjects...
- From: Kieran Kelleher <email@hidden>
- Date: Mon, 3 Jan 2005 10:32:42 -0500
Nathan,
I find MySQL much faster than that for big data sets. About 2 million
record (each record having about a dozen text fields) tab file or csv
file import into MySQL using LOAD DATA INFILE from a file on the local
machine takes no more than a couple of minutes. I know OpenBase is a
popular product, but may be slower for huge tables of millions of
records. Just an FYI .... not intended as a flame war starter!
-Kieran
PS. Use Innodb table type for ACID transactional database tables
instead of MyISAM tables. It's just an option in the create table
statement or can be set as a default in the my.cnf config file.
________________________________________________________________
Dev Config = OS X 10.3.5 / Java 1.4.2_05 / WO 5.2.3 / XCode v1.5 /
MySQL 4.0.20 / Connector-J 3.0.11
Deploy Config = OS X 10.3.5 Server / Java 1.4.2_05 / WO 5.2.3 / MySQL
4.0.20 / Connector-J 3.0.11
My Blog: http://webobjects.webhop.org/
On Jan 3, 2005, at 2:53 AM, Clint Fleetwood wrote:
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:
email@hidden
This email sent to email@hidden
_______________________________________________
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