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
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
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
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