但是数据文件超过2G，或者更大总不会是什么好事吧。不知道这里有没有更好的办
法？？

Fluke 写道:
> bsddb相当强悍的。。大型并发应用绝对没有问题，哈哈
>
> On 10/31/07, *BloodMage* <zhouyisu在gmail.com
> zhouyisu在gmail.com>> wrote:
>
>     谢谢，那我就放心了～～～
>
>     2007/10/31, Jiahua Huang <jhuangjiahua在gmail.com
>     jhuangjiahua在gmail.com>>:
>
>         没有问题.
>         _______________________________________________
>         python-chinese
>         Post: send python-chinese在lists.python.cn
>         python-chinese在lists.python.cn>
>         Subscribe: send subscribe to
>         python-chinese-request在lists.python.cn
>         python-chinese-request在lists.python.cn>
>         Unsubscribe: send unsubscribe to
>         python-chinese-request在lists.python.cn
>         python-chinese-request在lists.python.cn>
>         Detail Info: http://python.cn/mailman/listinfo/python-chinese
>
>
>
>     _______________________________________________
>     python-chinese
>     Post: send python-chinese在lists.python.cn
>     python-chinese在lists.python.cn>
>     Subscribe: send subscribe to
>     python-chinese-request在lists.python.cn
>     python-chinese-request在lists.python.cn>
>     Unsubscribe: send unsubscribe to
>     python-chinese-request在lists.python.cn
>     python-chinese-request在lists.python.cn>
>     Detail Info: http://python.cn/mailman/listinfo/python-chinese
>     <http://python.cn/mailman/listinfo/python-chinese>
>
>
>
>
> -- 
> Yours,
> fluke
> fluke在sfcube.net fluke在sfcube.net>
> http://blog.ospattern.net
> ------------------------------------------------------------------------
>
> _______________________________________________
> python-chinese
> Post: send python-chinese在lists.python.cn
> Subscribe: send subscribe to python-chinese-request在lists.python.cn
> Unsubscribe: send unsubscribe to  python-chinese-request在lists.python.cn
> Detail Info: http://python.cn/mailman/listinfo/python-chinese

lrython在gmail.com wrote:
> 但是数据文件超过2G，或者更大总不会是什么好事吧。不知道这里有没有更好的办
> 法？？

放心啦，只有玩具数据库才会以2G作为限制。BerkeleyDB支持大文件一点问题都没 
有，不过 Python 上面有好几种 BDB 的接口，注意不要用到系统内建的那个 
BerkeleyDB 1.85 就好了。

Cheers,

Google 的用户数据库就是使用 bdb 的。在 Oracle 的 showcase 里面有 pdf 简单的说明其架构。

在 07-11-1，lrython在gmail.com<lrython在gmail.com> 写道：
> 但是数据文件超过2G，或者更大总不会是什么好事吧。不知道这里有没有更好的办
> 法？？
>
> Fluke 写道:
> > bsddb相当强悍的。。大型并发应用绝对没有问题，哈哈
> >
> > On 10/31/07, *BloodMage* <zhouyisu在gmail.com
> > zhouyisu在gmail.com>> wrote:
> >
> >     谢谢，那我就放心了～～～
> >
> >     2007/10/31, Jiahua Huang <jhuangjiahua在gmail.com
> >     jhuangjiahua在gmail.com>>:
> >
> >         没有问题.
> >         _______________________________________________
> >         python-chinese
> >         Post: send python-chinese在lists.python.cn
> >         python-chinese在lists.python.cn>
> >         Subscribe: send subscribe to
> >         python-chinese-request在lists.python.cn
> >         python-chinese-request在lists.python.cn>
> >         Unsubscribe: send unsubscribe to
> >         python-chinese-request在lists.python.cn
> >         python-chinese-request在lists.python.cn>
> >         Detail Info: http://python.cn/mailman/listinfo/python-chinese
> >
> >
> >
> >     _______________________________________________
> >     python-chinese
> >     Post: send python-chinese在lists.python.cn
> >     python-chinese在lists.python.cn>
> >     Subscribe: send subscribe to
> >     python-chinese-request在lists.python.cn
> >     python-chinese-request在lists.python.cn>
> >     Unsubscribe: send unsubscribe to
> >     python-chinese-request在lists.python.cn
> >     python-chinese-request在lists.python.cn>
> >     Detail Info: http://python.cn/mailman/listinfo/python-chinese
> >     <http://python.cn/mailman/listinfo/python-chinese>
> >
> >
> >
> >
> > --
> > Yours,
> > fluke
> > fluke在sfcube.net fluke在sfcube.net>
> > http://blog.ospattern.net
> > ------------------------------------------------------------------------
> >
> > _______________________________________________
> > python-chinese
> > Post: send python-chinese在lists.python.cn
> > Subscribe: send subscribe to python-chinese-request在lists.python.cn
> > Unsubscribe: send unsubscribe to  python-chinese-request在lists.python.cn
> > Detail Info: http://python.cn/mailman/listinfo/python-chinese
>
> _______________________________________________
> python-chinese
> Post: send python-chinese在lists.python.cn
> Subscribe: send subscribe to python-chinese-request在lists.python.cn
> Unsubscribe: send unsubscribe to  python-chinese-request在lists.python.cn
> Detail Info: http://python.cn/mailman/listinfo/python-chinese

ÄãÓ²Òª·ÖСµÄ»°£¬µ±È»Óа취£¬¸ù¾ÝÄã×Ô¼ºÊý¾ÝµÄÌصã¿ÉÒÔ°ÑÊý¾Ý·Ö¶à¿âÀ´´æ·Å£¬²»¹ý×Ô¼ºÒªµ¥¶ÀÉèÖÃһЩ¿âÀ´Î¬»¤¶îÍâµÄË÷Òý£¬ÔÚ²éѯ³ÌÐòÉÏÏȾ­¹ýÒ»²ãÂß¼­À´Ñ¡ÔñÄĸö¿â¡£ÆäʵһÇж¼Òª¸ù¾ÝÄãµÄÊý¾ÝºÍ²éѯµÄÌصãÀ´ÓÅ»¯¡£

On 11/1/07, lrython在gmail.com <lrython在gmail.com> wrote:
>
> µ«ÊÇÊý¾ÝÎļþ³¬¹ý2G£¬»òÕ߸ü´ó×ܲ»»áÊÇʲôºÃÊ°ɡ£²»ÖªµÀÕâÀïÓÐûÓиüºÃµÄ°ì
> ·¨£¿£¿
>
> Fluke дµÀ:
> > bsddbÏ൱ǿº·µÄ¡£¡£´óÐͲ¢·¢Ó¦Óþø¶ÔûÓÐÎÊÌ⣬¹þ¹þ
> >
> > On 10/31/07, *BloodMage* <zhouyisu在gmail.com
> > zhouyisu在gmail.com>> wrote:
> >
> >     лл£¬ÄÇÎҾͷÅÐÄÁË¡«¡«¡«
> >
> >     2007/10/31, Jiahua Huang <jhuangjiahua在gmail.com
> >     jhuangjiahua在gmail.com>>:
> >
> >         ûÓÐÎÊÌâ.
> >         _______________________________________________
> >         python-chinese
> >         Post: send python-chinese在lists.python.cn
> >         python-chinese在lists.python.cn>
> >         Subscribe: send subscribe to
> >         python-chinese-request在lists.python.cn
> >         python-chinese-request在lists.python.cn>
> >         Unsubscribe: send unsubscribe to
> >         python-chinese-request在lists.python.cn
> >         python-chinese-request在lists.python.cn>
> >         Detail Info: http://python.cn/mailman/listinfo/python-chinese
> >
> >
> >
> >     _______________________________________________
> >     python-chinese
> >     Post: send python-chinese在lists.python.cn
> >     python-chinese在lists.python.cn>
> >     Subscribe: send subscribe to
> >     python-chinese-request在lists.python.cn
> >     python-chinese-request在lists.python.cn>
> >     Unsubscribe: send unsubscribe to
> >     python-chinese-request在lists.python.cn
> >     python-chinese-request在lists.python.cn>
> >     Detail Info: http://python.cn/mailman/listinfo/python-chinese
> >     <http://python.cn/mailman/listinfo/python-chinese>
> >
> >
> >
> >
> > --
> > Yours,
> > fluke
> > fluke在sfcube.net fluke在sfcube.net>
> > http://blog.ospattern.net
> > ------------------------------------------------------------------------
> >
> > _______________________________________________
> > python-chinese
> > Post: send python-chinese在lists.python.cn
> > Subscribe: send subscribe to python-chinese-request在lists.python.cn
> > Unsubscribe: send unsubscribe to  python-chinese-request在lists.python.cn
> > Detail Info: http://python.cn/mailman/listinfo/python-chinese
>
> _______________________________________________
> python-chinese
> Post: send python-chinese在lists.python.cn
> Subscribe: send subscribe to python-chinese-request在lists.python.cn
> Unsubscribe: send unsubscribe to  python-chinese-request在lists.python.cn
> Detail Info: http://python.cn/mailman/listinfo/python-chinese




-- 
Yours,
  fluke
fluke在sfcube.net
http://blog.ospattern.net
-------------- 下一部分 --------------
Ò»¸öHTML¸½¼þ±»ÒƳý...
URL: http://python.cn/pipermail/python-chinese/attachments/20071101/7dee9613/attachment.html 

哎，一直在搞商业化的oracle，这些较大型的开源数据库其实更加实用啊。万一哪天换公司买不起商业数据库，就抓瞎咯。

在07-11-1，Fluke <fluke.l在gmail.com> 写道：
>
>
> 你硬要分小的话，当然有办法，根据你自己数据的特点可以把数据分多库来存放，不过自己要单独设置一些库来维护额外的索引，在查询程序上先经过一层逻辑来选择哪个库。其实一切都要根据你的数据和查询的特点来优化。
>
> On 11/1/07, lrython在gmail.com <lrython在gmail.com> wrote:
> >
> > 但是数据文件超过2G，或者更大总不会是什么好事吧。不知道这里有没有更好的办
> > 法？？
> >
> > Fluke 写道:
> > > bsddb相当强悍的。。大型并发应用绝对没有问题，哈哈
> > >
> > > On 10/31/07, *BloodMage* <zhouyisu在gmail.com
> > > zhouyisu在gmail.com >> wrote:
> > >
> > >     谢谢，那我就放心了～～～
> > >
> > >     2007/10/31, Jiahua Huang <jhuangjiahua在gmail.com
> > >     jhuangjiahua在gmail.com>>:
> > >
> > >         没有问题.
> > >         _______________________________________________
> > >         python-chinese
> > >         Post: send python-chinese在lists.python.cn
> > >         python-chinese在lists.python.cn>
> > >         Subscribe: send subscribe to
> > >         python-chinese-request在lists.python.cn
> > >         python-chinese-request在lists.python.cn>
> > >         Unsubscribe: send unsubscribe to
> > >         python-chinese-request在lists.python.cn
> > >         python-chinese-request在lists.python.cn >
> > >         Detail Info: http://python.cn/mailman/listinfo/python-chinese
> > >
> > >
> > >
> > >     _______________________________________________
> > >     python-chinese
> > >     Post: send python-chinese在lists.python.cn
> > >     python-chinese在lists.python.cn >
> > >     Subscribe: send subscribe to
> > >     python-chinese-request在lists.python.cn
> > >     python-chinese-request在lists.python.cn>
> > >     Unsubscribe: send unsubscribe to
> > >     python-chinese-request在lists.python.cn
> > >     python-chinese-request在lists.python.cn>
> > >     Detail Info: http://python.cn/mailman/listinfo/python-chinese
> > >     <http://python.cn/mailman/listinfo/python-chinese>
> > >
> > >
> > >
> > >
> > > --
> > > Yours,
> > > fluke
> > > fluke在sfcube.net fluke在sfcube.net>
> > > http://blog.ospattern.net
> > >
> > ------------------------------------------------------------------------
> > >
> > > _______________________________________________
> > > python-chinese
> > > Post: send python-chinese在lists.python.cn
> > > Subscribe: send subscribe to python-chinese-request在lists.python.cn
> > > Unsubscribe: send unsubscribe to  python-chinese-request在lists.python.cn
> >
> > > Detail Info: http://python.cn/mailman/listinfo/python-chinese
> >
> > _______________________________________________
> > python-chinese
> > Post: send python-chinese在lists.python.cn
> > Subscribe: send subscribe to python-chinese-request在lists.python.cn
> > Unsubscribe: send unsubscribe to
> > python-chinese-request在lists.python.cn
> > Detail Info: http://python.cn/mailman/listinfo/python-chinese
>
>
>
>
> --
> Yours,
>   fluke
> fluke在sfcube.net
> http://blog.ospattern.net
> _______________________________________________
> python-chinese
> Post: send python-chinese在lists.python.cn
> Subscribe: send subscribe to python-chinese-request在lists.python.cn
> Unsubscribe: send unsubscribe to  python-chinese-request在lists.python.cn
> Detail Info: http://python.cn/mailman/listinfo/python-chinese
>
-------------- 下一部分 --------------
一个HTML附件被移除...
URL: http://python.cn/pipermail/python-chinese/attachments/20071101/8d3bc50f/attachment.html 

NTFS最大支持到64GB，BerkeleyDB最大到4TB，都没有问题。
另外，如果你使用dbhash肯定会遇到并发问题，推荐用bsddb.hashopen来打开数据库。
http://gashero.yeax.com/?p=5

ллÁË£¬²»¹ý¸Ð¾õËæ»ú·ÃÎÊÊý¾Ý¿â»¹ÊÇÓеãСÎÊÌ⣬ÎÒÔÚ10000´Î·ÃÎʺóCache¾Í¼¸ºõÈ«ÊÇÊý¾Ý¿âÁË¡£

ÔÚ07-11-1£¬doudou doudou <array.doudou在gmail.com> дµÀ£º
>
> NTFS×î´óÖ§³Öµ½64GB£¬BerkeleyDB×î´óµ½4TB£¬¶¼Ã»ÓÐÎÊÌâ¡£
> ÁíÍ⣬Èç¹ûÄãʹÓÃdbhash¿Ï¶¨»áÓöµ½²¢·¢ÎÊÌ⣬ÍƼöÓÃbsddb.hashopenÀ´´ò¿ªÊý¾Ý¿â¡£
> http://gashero.yeax.com/?p=5
> _______________________________________________
> python-chinese
> Post: send python-chinese在lists.python.cn
> Subscribe: send subscribe to python-chinese-request在lists.python.cn
> Unsubscribe: send unsubscribe to  python-chinese-request在lists.python.cn
> Detail Info: http://python.cn/mailman/listinfo/python-chinese
-------------- 下一部分 --------------
Ò»¸öHTML¸½¼þ±»ÒƳý...
URL: http://python.cn/pipermail/python-chinese/attachments/20071103/882aad13/attachment.html 

好事啊，cache可以加快访问速度么，另外，你仔细看看hashopen可以指定BDB使用的缓存大小的。但是说实在的，那个缓存的效率，我是不太满意的，速度慢。