How about for large amounts (500,000?) of small records that never change after they are created? Thanks, Derek Basch --- Ed Colmar <ed@greengraphics.net> wrote:
On Fri, 10 May 2002, Derek Basch wrote:
Speaking of which, can anyone tell me the practical size limit of the ZODB? For example, could 100,000 small documents be stored and indexed/searched without much trouble? How many records could I store using the BTree package? Is an SQL back-end my best choice for large amounts of small records?
Hi Derek
the ZODB is best suited for objects that don't change very freuqenctly, or that you need to be able to undo.
For small records that are changing, SQL is by far the best way to go.
-ed-
-- Green Graphics ::: Print and Web Design ::: 510.923.0000
__________________________________________________ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com
Derek Basch writes:
How about for large amounts (500,000?) of small records that never change after they are created? I would go for a relational database:
better search support, probably faster searches, no need for specialized products (e.g. BTreeFolder) Dieter
Thanks Dieter, I think that Firebird/Interbase will meet my needs very nicely. I have spent the last day playing with it and am a bit confused on how to get the Kinterbasdb Python Extension Package and the ZFireBirdDA Product working. http://kinterbasdb.sourceforge.net/ http://www.zope.org/Members/philh/ZFireBirdDA I have programmed python for about 3 months and this is the first I have had to use an Extension Package. The kinterbasdb Extension has source and binary distributions. The binary dist looks in the registry for a python installation so it wont work for zope (Im guessing). What is the best way to install the source dist with Zope? When I attempt to complile the source dist using zopes python interpreter (Zope\bin) I get this error: COMPILER CONFIGURATION ERROR: Unable to create a Borland-compatible Python library file using the coff2omf utility. Tried command: coff2omf C:\PROGRA~1\TelOnyx\bin\libs\python21.lib C:\PROGRA~1\TelOnyx\bin\l ibs\python21_bcpp.lib Thanks Again, Derek Basch --- Dieter Maurer <dieter@handshake.de> wrote:
Derek Basch writes:
How about for large amounts (500,000?) of small records that never change after they are created?
I would go for a relational database:
better search support, probably faster searches, no need for specialized products (e.g. BTreeFolder)
__________________________________________________ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com
Thanks again for the reply Dieter, You seem to mop up all the silly questions that no one else wants to answer :) I too try to stay MS free but the product I am designing is MS dependent. I am having a bear of a time getting Firebird/Interbase to work with zope. (No examples/docs I can find after 3 days of googling) I suppose this is where a Storage and Programming background rather than a Network Engineering background would come in handy. (Sighs and clears space in brain for learning Storage....). *********If anyone with Firebird/Interbase/Zope experience reads this and is feeling helpfull please drop me a line.*********** Thanks, Derek Basch --- Dieter Maurer <dieter@handshake.de> wrote:
Derek Basch writes:
... installing Kinterbasdb on Windows ...
Sorry, I cannot help you to install something on Windows.
I have been successful, to be almost MS-free...
Dieter
__________________________________________________ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com
[Derek Basch]
I too try to stay MS free but the product I am designing is MS dependent. I am having a bear of a time getting Firebird/Interbase to work with zope. (No examples/docs I can find after 3 days of googling) I suppose this is where a Storage and Programming background rather than a Network Engineering background would come in handy. (Sighs and clears space in brain for learning Storage....).
I tried to use Firebird about a year ago and couldn't get it to work right. Nothing to do with Zope. I forget just what it was, perhaps the odbc driver. I ended up using Interbase instead (I found a driver for it), and that worked fine with Zope using the odbc adapter. By now, the wrinkles have probably been ironed out and Firebird probably would work if I tried it again. See if you can get the database working in Windows using odbc - there are a few free interactive tools you can use to get data in and out of it, I think. Once it is working with odbc, you should be able to use it in Zope. Cheers, Tom P
participants (3)
-
Derek Basch -
Dieter Maurer -
Thomas B. Passin