Re: SQL performance - any way to improve?

[Mark Stosberg <mark@summersault.com>]

******    message to minivend-users from Mark Stosberg <mark@summersault.com>     ******


Alan,

 My own method has been to write my own Perl/DBI code that accesses the
same database. I made sure that my code is always entered through
Minivend space, so I can pick up the session ID and carry it around, so
I can connect to Minivend's other functions later. snippets of my code
look like this for a form:

<INPUT TYPE=hidden NAME=mv_session_id VALUE="[data session id]"> 

and this for a link:
<a href="/cgi/search.cgi?rs=3&ck=Chopin&cs=composer&sid=[data session id]">
search.cgi is my own code, with my own variables in the query string,
this just to show you how you might put the session ID in the query string.

 From some simple testing I've done comparing Minivend SQL searches with
my own, minivend is about 5 times slower. I'm interested in looking
inside the Minivend code to see if the SQL code by optimized. I've
queried the author about where the best place to start might be.

 -mark


Alan Sparks wrote:
> 
> ******    message to minivend-users from "Alan Sparks" <asparks@nss.harris.com>     ******
> 
> I've got Oracle as a database for the store, and performance is generally
> pretty poor.  In a couple of cases, I have an [sql type=list] type loop that
> fetches about maybe 255 records (for a billing address list)... the query in
> Oracle runs in a second or so, but Minivend takes a minute or so to do the
> same thing.
> 
> Are there any ways to improve performance while using an external database?
> Thanks.
> -Alan
> 
> =============
> Alan Sparks, IS Engineering Support
> <asparks@nss.harris.com>
> Harris Communications, Camarillo CA                   (805) 389-2430
> 
> -
> To unsubscribe from the list, DO NOT REPLY to this message.  Instead, send
> email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
> Archive of past messages: http://www.minivend.com/minivend/minivend-list

-- 
http://flip.summersault.com/
-
To unsubscribe from the list, DO NOT REPLY to this message.  Instead, send
email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
Archive of past messages: http://www.minivend.com/minivend/minivend-list