RE: [ZODB-Dev] Re: ZODB with a Relational Database
[José Carlos Senciales] > How can i know if i have my Python configured with large file support ? > > My version is: > > Zope Version (Zope 2.8.4-final, python 2.3.5, win32) > Python Version 2.3.5 (#62, Feb 8 2005, 16:23:02) [MSC v.1200 32 bit (Intel)] System > Platform win32 All flavors of Windows Python have supported "large files" since Python 2.2, so that's not the problem. You didn't say _which_ version of Windows you're using, though, and that may be the problem. Here from the NEWS file for Python 2.2a3: """ - Large file support is now enabled on Win32 platforms as well as on Win64. This means that, for example, you can use f.tell() and f.seek() to manipulate files larger than 2 gigabytes (provided you have enough disk space, and are using a Windows filesystem that supports large partitions). Windows filesystem limits: FAT has a 2GB (gigabyte) filesize limit, and large file support makes no difference there. FAT32's limit is 4GB, and files >= 2GB are easier to use from Python now. NTFS has no practical limit on file size, and files of any size can be used from Python now. """ If you're using a Windows version earlier than Windows NT, you're also using FAT or FAT32, and nothing can be done on those to overcome the filesystem limitations -- but then you shouldn't be trying to do serious work on a Windows system earlier than NT anyway, or with a filesystem earlier than NTFS. If you're running Win NT, 2000, 2003, or XP, and are using NTFS, you shouldn't have any filesystem-related problems no matter how large Data.fs gets. ___ For more information about ZODB, see the ZODB Wiki: http://www.zope.org/Wikis/ZODB/ ZODB-Dev mailing list - ZODB-Dev@zope.org http://mail.zope.org/mailman/listinfo/zodb-dev
Re: [ZODB-Dev] Re: ZODB with a Relational Database
José Carlos Senciales schrieb: thanks my phyton console return "0L", so i have have large file support. So if you still experience problems with files >2GB, you might move to another filesystem (if moving to another OS is not an option ;) ___ For more information about ZODB, see the ZODB Wiki: http://www.zope.org/Wikis/ZODB/ ZODB-Dev mailing list - ZODB-Dev@zope.org http://mail.zope.org/mailman/listinfo/zodb-dev
Re: [ZODB-Dev] Re: ZODB with a Relational Database
thanks my phyton console return "0L", so i have have large file support. - Original Message - From: "Tino Wildenhain" <[EMAIL PROTECTED]> To: "José Carlos Senciales" <[EMAIL PROTECTED]> Cc: "Dennis Allison" <[EMAIL PROTECTED]>; "Florent Guillaume" <[EMAIL PROTECTED]>; Sent: Wednesday, January 04, 2006 11:16 AM Subject: Re: [ZODB-Dev] Re: ZODB with a Relational Database José Carlos Senciales schrieb: thanks How can i know if i have my Python configured with large file support ? My version is: Zope Version (Zope 2.8.4-final, python 2.3.5, win32) Python Version 2.3.5 (#62, Feb 8 2005, 16:23:02) [MSC v.1200 32 bit (Intel)] System Platform win32 double-klick on the python.exe or start it in a console window and try: >>> f=open("somefile.txt","w") >>> f.tell() 0L >>> if its 0L, you probably have large file support. If its just 0, you probably dont. Not sure if on windows it also depends on the filesystem you use. Try with NTFS if in doubt. Regards Tino ___ For more information about ZODB, see the ZODB Wiki: http://www.zope.org/Wikis/ZODB/ ZODB-Dev mailing list - ZODB-Dev@zope.org http://mail.zope.org/mailman/listinfo/zodb-dev
Re: [ZODB-Dev] Re: ZODB with a Relational Database
José Carlos Senciales schrieb: thanks How can i know if i have my Python configured with large file support ? My version is: Zope Version (Zope 2.8.4-final, python 2.3.5, win32) Python Version 2.3.5 (#62, Feb 8 2005, 16:23:02) [MSC v.1200 32 bit (Intel)] System Platform win32 double-klick on the python.exe or start it in a console window and try: >>> f=open("somefile.txt","w") >>> f.tell() 0L >>> if its 0L, you probably have large file support. If its just 0, you probably dont. Not sure if on windows it also depends on the filesystem you use. Try with NTFS if in doubt. Regards Tino ___ For more information about ZODB, see the ZODB Wiki: http://www.zope.org/Wikis/ZODB/ ZODB-Dev mailing list - ZODB-Dev@zope.org http://mail.zope.org/mailman/listinfo/zodb-dev
Re: [ZODB-Dev] Re: ZODB with a Relational Database
thanks How can i know if i have my Python configured with large file support ? My version is: Zope Version (Zope 2.8.4-final, python 2.3.5, win32) Python Version 2.3.5 (#62, Feb 8 2005, 16:23:02) [MSC v.1200 32 bit (Intel)] System Platform win32 thanks jose carlos - Original Message - From: "Dennis Allison" <[EMAIL PROTECTED]> To: "Florent Guillaume" <[EMAIL PROTECTED]> Cc: "José Carlos Senciales" <[EMAIL PROTECTED]>; Sent: Tuesday, January 03, 2006 5:09 PM Subject: Re: [ZODB-Dev] Re: ZODB with a Relational Database José-- You can use MySQL and Zope without a running ZEO. The relational database and the object-oriented database are independent. Zope can be configured to manage the ZODB directly or via ZEO. You can also use the relational database as the store for the object-oriented database, replacing Data.fs. There has been some discussion of this on the web and in the archives, but I have no experience with this approach. I'm guessing that much of the discussion has been "proof of concept" and a relational store has not seen much use in production. I am interested in the performance trade-offs, but have not had time to experiment; Florent's ORM mappers sounds very interesting. Which version of Python and which version of Zope are you using? If you are having problems with a 2GB or greater Data.fs, check to be sure that your Python has been configured with large file support. Remember that the Python Zope uses may be different from that used elsewhere in the system. On Tue, 3 Jan 2006, Florent Guillaume wrote: José Carlos Senciales wrote: > I´m wondering if i can use ZODB without files ´Data.fs´ and use a > ralational database like Mysql to save the objects... > > is this possible?? > > i´m reading about ZEO, but how can i use ZODB with MySQL and without > use > ZEO ?? There's no simple way at the moment. However one of the big ongoing projects here at Nuxeo is to write a proper ORM mapper at the ZODB level. I'll be blogging about this soon. > Actually i´m using Zope with ZODB but when my file "Data.fs" get around > 2GB can not work properly. 2GB is not a problem, we've seen plenty of Data.fs with more than 10GB. Florent -- ___ For more information about ZODB, see the ZODB Wiki: http://www.zope.org/Wikis/ZODB/ ZODB-Dev mailing list - ZODB-Dev@zope.org http://mail.zope.org/mailman/listinfo/zodb-dev
Re: [ZODB-Dev] Re: ZODB with a Relational Database
José-- You can use MySQL and Zope without a running ZEO. The relational database and the object-oriented database are independent. Zope can be configured to manage the ZODB directly or via ZEO. You can also use the relational database as the store for the object-oriented database, replacing Data.fs. There has been some discussion of this on the web and in the archives, but I have no experience with this approach. I'm guessing that much of the discussion has been "proof of concept" and a relational store has not seen much use in production. I am interested in the performance trade-offs, but have not had time to experiment; Florent's ORM mappers sounds very interesting. Which version of Python and which version of Zope are you using? If you are having problems with a 2GB or greater Data.fs, check to be sure that your Python has been configured with large file support. Remember that the Python Zope uses may be different from that used elsewhere in the system. On Tue, 3 Jan 2006, Florent Guillaume wrote: > José Carlos Senciales wrote: > > I´m wondering if i can use ZODB without files ´Data.fs´ and use a > > ralational database like Mysql to save the objects... > > > > is this possible?? > > > > i´m reading about ZEO, but how can i use ZODB with MySQL and without use > > ZEO ?? > > There's no simple way at the moment. > > However one of the big ongoing projects here at Nuxeo is to write a proper > ORM mapper at the ZODB level. I'll be blogging about this soon. > > > Actually i´m using Zope with ZODB but when my file "Data.fs" get around > > 2GB can not work properly. > > 2GB is not a problem, we've seen plenty of Data.fs with more than 10GB. > > Florent > > -- ___ For more information about ZODB, see the ZODB Wiki: http://www.zope.org/Wikis/ZODB/ ZODB-Dev mailing list - ZODB-Dev@zope.org http://mail.zope.org/mailman/listinfo/zodb-dev