Thanks, Matt.
Maybe we can contribute to it and get it back in. This kind of thing is
nearly impossible in PHP (with Creole + Propel).
Thanks for all the help so far. It's very much appreciated.
-Frank
Matt S Trout wrote:
On Mon, Jun 04, 2007 at 05:10:09PM -0400, Frank Speiser wrote:
Hi All,
I am having a debate here with my friend, whom I'll call PHPGuy.
We're discussing scalability and using DBIC to handle multiple DBs.
Eventually we're going to want to do LJ-style user clusters using the
same idea here, but for now, I am saying that you can split the
read-write and read-only traffic (and that it'll work just fine). So, if
I was editing a profile, I'd use the read-write handle to get data, but
otherwise if I were browsing it, I'd use the read-only. The read-write
and read only would have different cache times for reads (as an example,
0 seconds and 300 seconds). It'd be nice to do this within DBIC.
http://search.cpan.org/perldoc?DBIx::Class::Storage::DBI::Replication
Marked experimental because the authors didn't write tests and nobody's told
us if it works for them yet, but it'll be shipped in 08 :)
Partitioning and caching will hopefully turn up for 09.
--
Frank Speiser
CTO
TAKKLE, Inc.
212.792.5854 (work)
212.792.5859 (fax)
[EMAIL PROTECTED]
_______________________________________________
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]/
