[Date Prev][Date Next][Thread Prev][Thread Next][Minivend by date
][Minivend by thread
]
SQL performance - any way to improve?
****** 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
