will be slower to retrieve info?

[Salvo]

HI all

 

I am slowly slowly (I will see what happen I hope I am doing ok) adding 15 fields to the products table.

 

Will it be a lot slower to retrieve information on screen or it will not be noticed due to the many extra fields?

 

Thanks

 

Salvo

[Jan0815]

That depends on implementation.

 

If you get all product information with one query it should have a minor effect only. But working through 15 extra code parts might slow things down.

 

My advice:

 

Enable the parse time logging functions and make some tests.

 

HTH

[Salvo]

Hi,

 

I think it will be all in one query as I am just using "model" field as example to create the others. ( I am a learner )

 

yes, I will do some tests once ready...

 

now I have another little question regarding on how to show this fields...

 

again I am using the "model" field...

the one below...

 

<?php

if (PRODUCT_LIST_MODEL) {

echo ' <tr>' . "n" .

' <td colspan="2" class="pageHeading">' . $product_info_values['products_model'] . '</td>' . "n" .

' </tr>' . "n";

}

?>

 

what about the second field, and so on. How can I show all the fields using the same "if" function..

 

do I have to repeat the above for each field? or what's the best way

 

example:

<?php

if (PRODUCT_LIST_MODEL2) {

echo ' <tr>' . "n" .

' <td colspan="2" class="pageHeading">' . $product_info_values['products_model2'] . '</td>' . "n" .

' </tr>' . "n";

}

?>

 

<?php

if (PRODUCT_LIST_MODEL3) {

echo ' <tr>' . "n" .

' <td colspan="2" class="pageHeading">' . $product_info_values['products_model3'] . '</td>' . "n" .

' </tr>' . "n";

}

?>