Categories

Updated: 12/17/2001

Oracle vs. MySQL: loading the data

Even though loading data from a text file into the database is not a task that user would perform on a daily basis, there are several cases when the speed of this process is important to DBA and company management. One example would be having a &"database guy&" receive the daily reports from the field offices or sales people on daily basis. Reports come as Excel documents or delimited spreadsheets of some kind, and DBA''s responsibility includes updating the database on constant basis, so that by the end of the day, he is able to give the management a report on the amount of daily sales or field office transactions. Here you will find a MS Word-format downloadable file that examines the benchmark results for Oracle and MySQL speed of loading the data from a text file.
©2003-2019 jCay.com