Realize that somewhere between 60 and 80 percent of performance problems are
poorly writen queries. I agree that if you are looking at PHP or Perl and
wondering about speed you are worring about the wrong thing up front. If
it's any consolation prize cmdrtaco from slashdot prefers Perl to PHP thoug
> i'm running an oracle enterprise server in a test
> environment for corereader, and i've noticed
> that, although oracle sometimes takes a while to
> wake up, after you have its attention, it throws
> data at you very fast. sometimes a developer
> does not use connections properly. in your case
Well, it looks like Simon has the best possible answer so far. I did a test
dump into a delimited file from Oracle and imported that using the LOAD
command in mysql and sustaned about 11,000 inserts a second. This is with no
indexes on the mysql tables at all. I have also tried using the dbtools
im
Well, This is my first attempt at moving from Oracle to MySQL on such a
large scale and so far it isn't going well at all. We are running oracle
7.3.4.0.1 and MySQL 4.0.4-0 standard. We are moving 101 tables with a total
of 45 millon records over. I have tried several diffrent methods including
usi
