[EMAIL PROTECTED] wrote: > first you need find the bottleneck of your script db or function > if the bottleneck is db > 1. which db do you use do you optimize the db from read > 2. the sql you write do not use any index "maybe select code, type > from products where type = 'I' or type = 'S' will help" and you need > create index on type field maybe you need set limit 2000 to sql depend > on your requirement > Whether a relational database is indexed or not the SQL to retrieve information from it will be exactly the same - the whole point if indexing is that it represents a change to the physical schema that improves retrieval efficiency without altering the logical schema.
Mike stated quite clearly "the db is normalized and indexes exist". regards Steve -- Steve Holden +1 571 484 6266 +1 800 494 3119 Holden Web LLC/Ltd http://www.holdenweb.com Skype: holdenweb http://del.icio.us/steve.holden --------------- Asciimercial ------------------ Get on the web: Blog, lens and tag the Internet Many services currently offer free registration ----------- Thank You for Reading ------------- -- http://mail.python.org/mailman/listinfo/python-list
