Jess Robinson wrote: > Loading from a single file versus many is slower? I wonder why, that > sounds odd to me, given that it only has to parse/load one file in the > first instance. > > Well, I first posted this thread because I was stunned by how slow the single-file load was. I felt I was doing something stupid, and I thought someone would point out whatever stupid thing I was doing.
When no-one posted anything that helped, I continued experimenting, and saw the difference with the multi-file load. The difference was also the difference between a tool I could use and a tool that was infeasible for a majority of my tasks. I don't know if the single-file load method can be speeded up or not, but to be quite honest, now that I've got a method that is fast enough for me, I'm happy, and I don't care about single file so much anymore... > Maybe the load diference is in the amount of column_info, or the rels.. > That's why I posted the whole shebang to the mailing list. I see from Matt's reply that it wasn't the reason. > Out of curiosity, which DB is it? The sqlt method should get your > relationships just fine.. > It was mysql. Dunno why sqlt didn't pick up the relationships, I thought I installed the latest version from CVS. Anyway DBIx::Class:Schema::Loader picks them up for me quite nicely, and since the resulting schema is also faster to load, it's a complete no-brainer. I want to thank all the authors for a wonderful tool. You've saved my bacon in the past few weeks. Thank you from the bottom of my heart. _______________________________________________ List: http://lists.rawmode.org/cgi-bin/mailman/listinfo/dbix-class Wiki: http://dbix-class.shadowcatsystems.co.uk/ IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/trunk/DBIx-Class/ Searchable Archive: http://www.mail-archive.com/[email protected]/
