[Zope] Re: genealogy product?

2007-09-07 Thread Max M
Mihamina (R12y) Rakotomandimby skrev: Hi, Would you know any genealogy product for Zope? Is zope a tool for managing a big (20 members) of genealogy oriented group, which has over 150,000,000 entries in the genealogy tree? It is now managed with about 20 servers and SQL databases but Zope

Re: [Zope] genealogy product?

2007-09-07 Thread Peter Bengtsson
I don't think there is such a Zope product. With that amount of members and entries it'd be best to write your own. 150,000,000 entries shouldn't require 20 servers!! Sure, you might need a decent database server and a decent application server but not 20. Unless they're 20 x Pentium 90 :) Mih

Re: [Zope] Re: [Zope-DB] case insensitive ZSQL queries

2007-09-07 Thread Peter Bengtsson
upper(lastname) like upper() * Don't use LIKE without any regular expression * Use ILIKE instead of UPPER(...) = UPPER(...) since it's usually faster (I've "proven" this for PostgreSQL at least) * Fastest method is always to use an index and you can write an index based on the UP

Re: [Zope] VERY unusual zope traceback

2007-09-07 Thread Dieter Maurer
robert rottermann wrote at 2007-9-7 05:47 +0200: >After my computer was iddling during the nigth I got the following >traceback. look at the rather genereous number of expected parameters. >how can somethings like this happen? Memory corruption? >restarting zope fixed it. > ... >* Module App.ZA