"J Ottery" <jottery@[EMAIL PROTECTED]
> wrote in message
news:b45d9570-66de-437b-b0d8-
> Simple Table.Append; ...... Table.Post; It is erroring on the Post
A professional developer way, when re****ting erros situations, is to tell
the exact error messages you are getting.
> Using a dbf file with 10 indexes and 500000 records and writing
My educated, brute force quess is that the table size could be something
like 50 MB. And index files something like 20 MB. In general, you should
still have reasonable 2..5 sec response times over 100 Mbit betwork. And
no
evident reason why this size dBase database would not work reliably with a
limited number of users.
It could still be a bug somewhere in your own code. Having as much as 10
different index on one physical table could mean also your code design
could
be a bit hairy.
> One more question: Perhaps you know, can I use mySQL to manage my
> current dbf type files?
Manage?? Well, you can use Delphi, VB, Perl, PHP etc. to write application
code that 'manages', that means reads and writes data to your dBase or
MySQL
database.
But I'm not able to imagine how MySQL could manage your DBF dBase files.
Of
course there are ways to copy, transfer your dBase table data to MySQL
database, if that was the question.
-Arian
|
