Extremely large tables
I have a question regarding the handling of very large tables with hundreds of columns.
I have a group of SAS tables that I want to load into a mysql database. The SAS tables follow groups of uniquely identified individuals through time. The tables are unique to the ID and the date, and each one contains between 1500 and 3000 variables, all of which are more or less unique to ID and time. The largest of the SAS files weigh in at over 15GB.
I'm trying to efficiently load everything into a group of Windows based MySQL databases and I need some advice on how to do it. I'm guessing that retaining the file structure of the 15GB SAS files is sub-optimal. Is there a best practice for this sort of thing? What do I need to know or keep in mind when managing this?
Subject
Views
Written By
Posted
Extremely large tables
3994
April 27, 2009 09:30PM
2243
April 28, 2009 11:01PM
2380
May 01, 2009 01:28PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.