Hi, Sure. t1 100 records t2 120,000,000 records create table t1 (c1 int, key30 varchar(30)); create table t2 (c1 int, key30 varchar(30)); update t1 set c1=(select c1 from t2 where t2.key30=t1.key30); To find 100 records with 30 bytes key takes about 3 minutes on 64bit Windows with 48GB memory and 2 Xenon CPUs, compared to other counts that I can do with this database that very, very slow. Thanks. Dariusz. Niels Nes wrote:
On Thu, Mar 26, 2009 at 01:42:59PM -0400, dariuszs wrote:
Hi, I've got 2 tables with 30 bytes varchar keys and matching those tables takes forever, eg. find 10 records from one table in another. Can you help with that? Thanks. Dariusz.
we would need more info for this, ie could you post your table definition and query?
Niels
------------------------------------------------------------------------------ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users