Factory pattern again

[Steve Holden]

cunheise at yahoo.com.cn 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 -------------