big table or several littles tables ?

[Ruslan Zasukhin]

On 9/27/04 7:15 PM, "olivier" <vidal_olivier at yahoo.fr> wrote:

>> If you will do 10 searches on 10 tables, you loose
> 
> no.
> but if I import a file of 1000 addresses and that I must check the
> streets of these 1000 addresses, I will make 1000 research each time in
> a different table.
> 
> e.g. :
> 
> Search street 1 -> in table 3
> Search street 2 -> in table 3
> Search street 3 -> in table 1
> Search street 4 -> in table 10
> Search street 5 -> in table 5
> Search street 6 -> in table 8
> Search street 6 -> in table 8

TIP

There is sense to sort this 1000 records by ZIP.

So you will execute at first 100 searches in T1,
Then 100 searches in T2
...


-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------