Dear Ash How can i log db calls? On Tue, Dec 2, 2014, 3:22 PM Ashley Sheridan <ash@xxxxxxxxxxxxxxxxxxxx> wrote: > > > On 2 December 2014 10:57:42 GMT+00:00, Farzan Dalaee < > farzan.dalaee@xxxxxxxxx> wrote: > >Dear Ash > > > >Thanks for your tips, about number two inline js for use multi tree > >view > >in one page, and i cant understand number three would you explain it > >please > >Thanks again for your consideration > >Best regards > >Farzan Dalaee > > Hi, just keeping the list copied in as this may benefit others. > > There are many ways to store hierarchical data in a db, the adjacency > method that you're using is simple to use, but slow and complex to execute > when there are many parent/child relationships. > > There are whole books on this subject, but http://stackoverflow.com/ > questions/192220/what-is-the-most-efficient-elegant-way-to- > parse-a-flat-table-into-a-tree/192462#192462 has a good explanation on > some other ways of storing hierarchical trees in MySQL and how to maintain > them through SQL. > > Maybe you could log the number of db calls you're making, as this might > show you how much is being done by the db just to show the full tree. > > Thanks, > Ash > Thanks, > Ash >
