Yes, I am aware that data normalization should be my priority (as it is).
- I've got a table with 65 columns storing vehicle data with columns:
priceand so forth, in total 65.
- Now, I can divide that and have a
VehicleExtra(all one-to-one with main
Let's assume I'll have about 5 million rows (vehicles).
SELECT with a
WHERE clause: Will the performance be better searching through (both cases indexed at least on
Vehicletable with 65 columns or
JOINSon four other tables (all with 5 million rows) to return all the data related to
(As per database engine, consider PostgreSQL and/or MySQL).
Truly appreciate any detailed insights you might have from your previous experience?
Updates will be rare if any, and selects will be mostly for all columns (vehicle details page) and main info (few columns) for search results list, and in fact maybe the best solution would be two tables: one with main info (few columns) and the other table with rest of the columns.