We have...
Database "MS" (MySQL) has a [widgets] table.
Database "4D" (4D) has a [modules] table.
A PHP webpage lists every widget in MS, with a separate line for each
related module from 4D. A few fields of metadata need to be displayed
for each module. Theoretically, which should be quicker to load:
• From PHP, loop through an array of widgets, sending an Active 4D
query out for each widget (200 widgets on the page --> 200 A4D queries)
- the A4D queries are short and direct.
OR
• From PHP, send an Active 4D query to grab all the data (distinct
values on [modules] widgets, explode each of those strings, make a
separate "entry" in the return string for each substring). When
looping through an array of widgets in PHP, look through the stored
array for related module information.
Thanks in advance for any advice you're able to offer!
Lisa
_______________________________________________
Active4D-dev mailing list
[email protected]
http://mailman.aparajitaworld.com/mailman/listinfo/active4d-dev
Archives: http://mailman.aparajitaworld.com/archive/active4d-dev/
