Dear Shmuel,
1) If you have large amounts of data to load into the DB, the fastest way by
far is to prepare a text file (I am using TSV: Tab-Separated-Values) and use
MySQL LOAD DATA INFILE statements. These are an order of magnitude faster.
Look it up at http://dev.mysql.com/doc/refman/5.1/en/load-data.html
2) MySQL does support multiple databases, e.g., `Test01`, `Test02`, etc. You
can address as many of these in a single query, by using a fully qualified
table name such as `Test01`.`Table_xyz`. (Please note that back-ticks are
separately surrounding the DB name and the table name.)
3) MySQL does support transactions, BUT:
* You must use the InnoDB storage engine
* And even that one does not always behave as expected. You better include
in your application explicit control, such as
---------
$sth = $dbh->do("START TRANSACTION");
# More DB manipulations...
$sth = $dbh->do("COMMIT WORK");
# or, if you want to roll it back, change this to $dbh->do("ROLLBACK")
---------
4) MySQL supports in memory tables which are volatile, they disappear when
you logout of MySQL.
Have fun!
Meir
_______________________________________________
Perl mailing list
[email protected]
http://mail.perl.org.il/mailman/listinfo/perl
