RE: [ZODB-Dev] Re: ZODB with a Relational Database

2006-01-04 Thread Tim Peters
[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

2006-01-04 Thread Tino Wildenhain

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

2006-01-04 Thread José Carlos Senciales

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

2006-01-04 Thread Tino Wildenhain

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

2006-01-04 Thread José Carlos Senciales

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

2006-01-03 Thread Dennis Allison

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