Quote:
Originally Posted by Red Knave
Delta splits it because it's proper database practice (and theory) to do so. MYSQL has a limit of 4K columns AFAIK.
You will waste time and resources storing BRIS data in the format that you get it. There is too much redundant data that way.
|
I understand normalization. I was trying to pull in the whole BRIS MCP file for storage and reference only. Maybe this is not a good idea. Yes, once in their needs to be a trainer table, a jockey table, and other PP info tables to join back to make today's race. How's performance on the PC using many joins?
__________________
"The Law, in its majestic equality, forbids the rich, as well as the poor, to sleep under bridges, to beg in the streets, and to steal bread."
Anatole France
|