Nested while loop problem very slow in query

[Lemon_Juice]

@molona

Secondly, don’t use the astherics (*) to add all the fields. I know that writing it is a pain but it is quicker for the database if you name each field that you want to show instead that using the astheris.

Example:

If a table has an id field, a name field and phone_number field, this query SELECT table.id, table.name, table.phone_number FROM table will execute faster than SELECT table.* FROM table

I remember doing some benchmarks some time ago and with mysql there was absolutely no speed difference between using an asterisk and listing all columns, even in a large loop.