How To optimize a database ?

Wed Dec 7 11:50:59 CST 2005

On 12/7/05 8:38 AM, "Thierry Nauze" <ohmitou at wanadoo.fr> wrote:

Hi Thierry, 

> Hello,
> 
> I have a DBbase with several tables from which one is more often
> requested than the others
> 
> Main table  t1:
>   id   A   B   C  ...
> 
> And here is a secondary table t2 :
> id   t1_id  D   E 
> 
> To obtain data A, B and D knowing t1.id, I need two requests SQL.

Why not by single with join ?

> I have to try to optimize situation by modifying the structure of the
> base
> 
> AFTER the modification, I have main Table t1
> id   A  B   C   D  ...
> 
> A single request is then necessary with a more simple code...
> 
> 
> And ... result is contrary to my expectations ! Where is the problem ?

You mean you get it slower?

What exactly operation become slow ?
Some operations have become faster?

Do you use Db.Select() and Cursor ?

> Question: is it preferable to have several tables with few columns or
> a single table with many columns?
> That is not maybe impossible!

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]