If MonetDB could use table partition ?

Stefan Manegold Stefan.Manegold at cwi.nl
Mon Jul 22 09:21:52 CEST 2013


Hi Meng,

are you loading all 1000 FITS files into the same table, or each in its own table?

What is the schema of your table, i.e., what are the types of the 21 columns?

Which operating system are you running on, and how much memory (RAM) does your machine have?

Stefan

----- Original Message -----
> I am using "COPY BINARY INTO ...FROM ..." to insert 1000 FITS files into a
> table and the table has 21 columns, every FITS file has 200000 records.
> After some FITS files, the loading becoming very slowly,
> 
> 
> so If MonetDB could use table partition to accelerating the copy?
> or if Data Vaults could be loading more quickly?
> 
> 
> Thanks!
> 
> 
> Meng
> _______________________________________________
> users-list mailing list
> users-list at monetdb.org
> http://mail.monetdb.org/mailman/listinfo/users-list
> 

-- 
| Stefan.Manegold at CWI.nl | DB Architectures   (DA) |
| www.CWI.nl/~manegold/  | Science Park 123 (L321) |
| +31 (0)20 592-4212     | 1098 XG Amsterdam  (NL) |




More information about the users-list mailing list