[Zope] Hardware for Zope + ZEO
Wankyu Choi
wankyu@neoqst.com
Fri, 31 Jan 2003 20:48:08 +0900
> Is there a way in Zope to limit the returned
> results as a limit clause would do in an SQL statement?
>>The best approach is to use ZCatalog. ZCatalog means you only need to =
load
the=20
>>articles into memory when you need them.
A threaded board needs to maintain its threaded structure. It's rather
cumbersome with SQL but efficient. In Zope, it's a snap but gives poor
performance. A folder (parent article) and its subfolders (its replies)
strucutre directly turns into a thread hierarchy.
I do use ZCatalog for all views of NeoBoard except for its default =
threaded
look. Maybe I was stupid in not using ZCatalog for the threaded look. =
I'll
give it a try.
But I just wanted to know if there was a way to pull a limited set of
objects from a **folderish object** not using ZCatalog.=20
Not sure if your suggestion would work with NeoBoard yet, but I ran into =
a
number of situations where I should pull all objects from a folder.
I posted a simliar query months ago when I was trying to write my own =
user
folder. No definate answer yet. The stock userfolder, for example, =
returns
every user object no matter how many there are in response to a getUsers
method call. I wouldn't use it with my 300,000 users. Nobody would, I
suspect. There was no info on how to pull a limited set of users from a =
user
folder. And guess we can't use ZCatalog to do the job. Simply put, are =
Zope
folderish objects including BTreeFolderish objects **not** designed to =
hold
this many objects? Well, if so, I'll just rewrite NeoBoard to use MySQL
again. That would be a lot easier :(
Thanks again for your time.
Regards,
Wankyu Choi
---------------------------------------------------------------
To the dedicated staff at NeoQuest, language is not a problem
to be dealt with, but an art waiting to be performed.
---------------------------------------------------------------
Wankyou Choi
CEO/President
NeoQuest Communications, Inc.
3rd Floor, HMC Bldg., 730-14, Yoksam-dong, Kangnam-gu
Seoul, Korea
Tel: 82-2 - 501 - 7124 Fax: 82-2-501-7058
Corporate Home: http://www.neoqst.com
Personal Home: http://www.zoper.net, http://www.neoboard.net
e-mail: wankyu@neoqst.com
--------------------------------------------------------------- =20