> Is mySQL up to such a task? I have been using mySQL for four years
> now, but have never used it in a project of this magnitude. We'll be
> handling financial data in the database, so integrity is important.
I think so. You find impressive statements on the mysql site
about speed & size & reliability incl. testimonials. Also, you
may want to consider the new innobase table type - see statements
at their site as well.
> Where can I find information about very large databases with mySQL?
See above. Also you will find statements in the list archives
lists.mysql.com, but you may have a harder time searching the
appropriate posts.
> Is there a really efficient way to implement a function like
> indexseek() in FoxPro? This function will simply check an index to tell you
> if a record with that key exists. Sort of like "select count(id) from Foo
> where id=1" except that it doesn't actually fetch the field value and it
> just checks the index file, not the data file.
As far as I know that's exactly what MySQL does.
--
Herzlich
Werner Stuerenburg
_________________________________________________
ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen
Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409
http://pferdezeitung.de
