News for hackers. Stuff that matters.

A comment on How MySQL memory table saved the day. Parent comment

Re:How MySQL memory table saved the day by jlarocco on Friday December 13, 2013 @01:37PM (#6902069)
84 fields in one table is terrible DB design, and I'm not surprised that it's slow.

If it were me, I'd split that one giant table into a "main" table with some basic information and foreign keys pointing to other tables with the more detailed information from the other sources.

[ Parent | on HN ]
Re:How MySQL memory table saved the day by webstartupper on Friday December 13, 2013 @02:27PM (#6902355)
Your assumption is that all fields are not required in the default search query.

In our case, joining 6 tables with 14 fields each is going to be much slower than running the query of just the table.

[ Parent | on HN ]