On Jan 5, 2007, at 6:22 PM, Neal Clark wrote:
> when I make a new table (called 'abc') from the same schema
> definition and load it with 1,000,000 rows from the malware_logs
> table, everything works fine. is it just a limitation of Rose::DB
> that it won't work with tables of this size? or is it a DBI issue?
>
> any suggestions would be very appreciated. like i said, i spent tons
> of time writing software using this ORM scheme that worked great
> until the table got this big, so I'm quite desperate for a way to
> make this work.
>
> For the record this is FreeBSD 6.1-RELEASE, mysql 14.12 Distrib
> 5.1.11-beta (from ports) and Rose::DB 0.758.
i think its neither rose::db or dbi -- i think its mysql.
check the comment at the bottom of this.
http://www.mysql.org/doc/refman/5.0/en/operating-system-error-
codes.html
also
http://dev.mysql.com/doc/refman/5.1/en/freebsd.html
note that i'm not familiar with mysql anymore. i dropped it long ago
for postgres. BUT when doing large things with postgres, I most
certainly did have to edit the postgres and kernel defaults to toss
more ram at things.
anyways, your CAUSE looks a lot like that sort of issue
// Jonathan Vanasco
| - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
- - - - - - - - - - - - - - - -
| FindMeOn.com - The cure for Multiple Web Personality Disorder
| Web Identity Management and 3D Social Networking
| - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
- - - - - - - - - - - - - - - -
| RoadSound.com - Tools For Bands, Stuff For Fans
| Collaborative Online Management And Syndication Tools
| - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
- - - - - - - - - - - - - - - -
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Rose-db-object mailing list
Rose-db-object@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/rose-db-object
