Dan, It is a little hard to offer suggestions on such code without seeing the code. If you post your code perhaps we can offer suggestions.
As an aside. Bill of Materials is not easy is the current level of SQL offered by RBase. The very lastest standards of the SQL standard offer some enhancements that make processing of Bill of Materials easier. You might want to check out Joe Cleko's book "Trees and Hierarchies in SQL for Smarties". Some of which is way over my head as I don't have a need for the "trees" central to Bill of Materials schemes. Jim Bentley American Celiac Society [email protected] tel: 1-504-737-3293 ----- Original Message ---- From: Dan Goldberg <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Friday, September 11, 2009 9:04:09 AM Subject: [RBASE-L] - nested while loops I have a nested while loop that I use for our bill of material calculation. It is about eight levels deep. When it runs it is slower than a non-nested loop. Does anyone have any pointers to make it run faster?? TIA Dan Goldberg
