Re: [Zope] Zope user limit?
DOES ANY ONE KNOW OF A MULTITHREADED DATABASE ADAPTOR FOR WINDOWS98? Gadfly just can't handle it. . I'm about to switch to apache mySql - this zope thing ain't workin out . . :( DARN because I love Zope so much ... pity.. thankX in advance :)
Ummm.. gadfly is not at all optimal for this. ;-( I don't believe gadfly is threaded at all.. but I haven't really investigated. Gadfly >is great as a demonstration/testing/play-around database, but it sounds like you probably need a "real" database. Since I don't do windows... >I
can't really recommend anything specific.. there are probably other folks on the list who can suggest a good one.
good luck! -steve
On Tuesday, March 5, 2002, at 06:44 PM, mick polo wrote: Steve wrote: What database adaptor are you using? Is it running fully threaded? How many threads have you given Zope to work with? There is a "-t" option on the startup script you can adjust. How big a query are you performing? --- I am using the ZgadflyDA adaptor. I'm not sure if that's fully threaded. on the "-t" option i've given zope a 100 threads to work with, which should be more than enough seeing there's only ~20 users using it at a time "Advanced" caching facility may help you to get higher throughput. --- Is setting the cache Higher or Lower better for throughput? Thanx heaps. Mike _________________________________________________________________ Chat with friends online, try MSN Messenger: http://messenger.msn.com
-> DOES ANY ONE KNOW OF A MULTITHREADED DATABASE ADAPTOR FOR WINDOWS98? -> -> Gadfly just can't handle it. . I'm about to switch to apache mySql - this -> zope thing ain't workin out . . :( DARN because I love Zope so much ... -> pity.. You can use Zope with MySQL instead of Gadfly. Problem solved. (And MySQL runs under MS-Windows.)
[mick polo]
DOES ANY ONE KNOW OF A MULTITHREADED DATABASE ADAPTOR FOR WINDOWS98?
Gadfly just can't handle it. . I'm about to switch to apache mySql - this zope thing ain't workin out . . :( DARN because I love Zope so much ... pity..
If you are thinking about mySql, use it with Zope. 1) Get and install the data base. Get it running and make sure you know how to start the server and can access it. 2) Either get the Zope native database adapter for it, or get the mySql odbc driver and the Zope odbc database adapter. If you use the odbc driver, you have to create an odbc data source using the Windows odbc manager (in the Control Panel). If you use odbc, it will be easier to change to another database later if you want to, but it's one more piece of softawre to find, install, and configure. If you use the native adapter, it should be faster but less portable if you need to change databases. Either way, make sure you are getting the right versions - you need the ones for Python 2.1 or Python 1.5.2 depending on which version of Zope you are running. 3) Use zsql methods with a Zope connection to the database. It will work fine on Windows. Cheers, Tom P
participants (3)
-
Derek Simkowiak -
mick polo -
Thomas B. Passin