[Zope] RE: Experience with Zope and Access

[Schmidt, Allen J.]

Well, not really an issue now. Following Tom P's advice (and something that
should have been obvious, I added new indexes to the 3 tables I was pulling
from and the query went from 35 seconds to 2 inside Zope using MySQL...I can
live with that. The last Access connection will be dropped within minutes...

Thanks to all who responded...

Allen

-----Original Message-----
From: Harlow Pinson [mailto:hpinson@indepthl.com]
Sent: Tuesday, November 13, 2001 4:28 PM
To: Schmidt, Allen J.
Subject: RE: Experience with Zope and Access


Hi Allen, 

>only until the next query comes in.
Yes

> Example
Well, this is what I use in Cold Fusion:

<!--- When called this bad query will remove locked datafile on the 
server --->
<cfquery datasource="#Application.DSN#">Delete locked .ldb 
datafile on server now</cfquery>

In Zope and ZSQL Method something like:
(using the DSN)
SELECT something_bogus FROM some table;




Harlow Pinson
Indepth Learning
Email: hpinson@indepthl.com 
Web: http://www.indepthl.com
Voice: 505-994-2135
FAX: 208-475-7678