[MonetDB-users] writing out all fields

Hi, Selecting 50 fields out of 300 takes almost no time to write out to csv file, but selecting everything takes forever - is there any setting that can improve the speed to write out all fields from a table? Thanks. Dariusz.

dariuszs wrote:
Hi, Selecting 50 fields out of 300 takes almost no time to write out to csv file, but selecting everything takes forever - is there any setting that can improve the speed to write out all fields from a table? Thanks. Dariusz. That depends on the size of your tables and the selectivity of your predicates. The worst situation is if your total database size does not fit in memory (swapspace), and you are selecting >95 and <100% of the tuples.
------------------------------------------------------------------------------ Apps built with the Adobe(R) Flex(R) framework and Flex Builder(TM) are powering Web 2.0 with engaging, cross-platform capabilities. Quickly and easily build your RIAs with Flex Builder, the Eclipse(TM)based development software that enables intelligent coding and step-through debugging. Download the free 60 day trial. http://p.sf.net/sfu/www-adobe-com _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
participants (2)
-
dariuszs
-
Martin Kersten