基于19列性能的mysql查询

Question

我是一个新手，当我来到mysql时，我一直在使用firebase数据库，它不是一个关系数据库，但对于mysql，我在查询列(过滤)方面有一个性能问题。我正在做这个汽车应用程序，大约有19个身份

ID  type    model   seri    marka   year bodytype   feul    Gear    picurl  km  color   warranty    from-who    Exchangable Conidition  city    neibourhood useride 

过滤器将如下所示

example: type = 2 and model = 3 and seri = 4 and marka =3 and year = 94 and bodytype = 5 and feul = 2 and gear = 3 and km >= 1000 and warrant = 4 and from-who = 4 and color = 3  and exchangable = 2 and conditition = 2 and city = 3 and neibourhood = 2

哪个更适合过滤:一个表有19列，或者2-5个索引表基于ID连接，因为用户将在执行查询注释之前使用过滤器(请注意，预计表中的大量数据将低于(10.000行)，因为创建4周后每行都会自行删除)

Answer 1

您可以使用以下方式运行查询：

SELECT * FROM cars WHERE  type = 2 and model = 3 and seri = 4 and marka = 3 and year = 94 and bodytype = 5 and feul = 2 and gear = 3 and km >= 1000 and warrant = 4 and `from-who` = 4 and color = 3  and exchangable = 2 and conditition = 2 and city = 3 and neibourhood = 2 ;

如果你想为所有的表建立关系，你必须遵循

• One to One
• One to Many
• 多对多