Data and search query speed?

[DanielH]

Hi Alejandro,

I have found a way that works for me to create data from lists to add my fields and the many options such as the 73,000+ entries for my address database and the many thousands of vehicle make, model, trim, engine, and specs etc. by default as the bulk of the sites data through custom fields.

The question is, will the data query speed be effected or slowed if the fieldoption data is not arranged in a numeric order or does it make no difference?

For example:

1) Listing all fieldoptions according to the numeric field id value relation. 1 1 1, 2 2 2, 3 3 3 etc

field id 1 manufacturer options controls field id 2 model options controls field id 3 trim options controls, field id 4 engine etc.
 

(, 1, '', '', '', , 'jr_make', '', 0, ''),
(, 1, '', '', '', , 'jr_make', '', 0, ''),
(, 1, '', '', '', , 'jr_make', '', 0, ''),
(, 2, '', '', '', , 'jr_model', '*make*', 0, ''),
(, 2, '', '', '', , 'jr_model', '*make*', 0, ''),
(, 2, '', '', '', , 'jr_model', '*make*', 0, ''),
(, 3, '', '', '', , 'jr_trim', '*model*', 0, ''),
(, 3, '', '', '', , 'jr_trim', '*model*', 0, ''),
(, 3, '', '', '', , 'jr_trim', '*model*', 0, ''),

vs 2) Arranging the fieldoptions according to the control fields option id as 1 2 3, 1 2 3, 1 2 3, 1 2 3 etc

(, 1, '', '', '', , 'jr_make', '', 0, ''),
(, 2, '', '', '', , 'jr_model', '*make*', 0, ''),
(, 3, '', '', '', , 'jr_trim', '*model*', 0, ''),
(, 1, '', '', '', , 'jr_make', '', 0, ''),
(, 2, '', '', '', , 'jr_model', '*make*', 0, ''),
(, 3, '', '', '', , 'jr_trim', '*model*', 0, ''),
(, 1, '', '', '', , 'jr_make', '', 0, ''),
(, 2, '', '', '', , 'jr_model', '*make*', 0, ''),
(, 3, '', '', '', , 'jr_trim', '*model*', 0, ''),

Hope the question makes sense. Just want static, common, data to be managed efficiently being there is going to be well over a hundred thousand data rows for addresses and vehicle info alone.

Thanks

 

[Alejandro]

This section is only visible with a valid subscription. If you have a valid subscription, please login.

[DanielH]

This section is only visible with a valid subscription. If you have a valid subscription, please login.