Hi, there is no such benchmark available. I doubt it would make a big difference. It might even be a little slower, because it increase the total memory footprint (e.g. the hashes needed) regards, Martin On 12/29/11 3:51 PM, Stefan de Konink wrote:

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA512

Hi,

MonetDB 'deduplicates' strings, is there any benchmark that outlines the performance difference of an ENUM with a low number of (string)items versus the use of a VARCHAR field?

The technical question would be;

Is it more efficient to do:

select * from my_table, my_enum where mytable.my_enum_id = my_enum.id and my_enum.name = 'Something';

or

select * from my_table where my_enum_varchar = 'something';

I can imagine that the following would out perform a string comparison, but implies hardcoded values.

select * from my_table, my_enum where mytable.my_enum_id = hardcoded;

Stefan -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.18 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iEYEAREKAAYFAk78fnkACgkQYH1+F2Rqwn3BUQCeOUtPIGzcHT1xpnsF4n78BQ/1 JWAAnjnzPeT8D7CtsjYgAiGg/WRIgNbQ =989f -----END PGP SIGNATURE-----

------------------------------------------------------------------------------ Ridiculously easy VDI. With Citrix VDI-in-a-Box, you don't need a complex infrastructure or vast IT resources to deliver seamless, secure access to virtual desktops. With this all-in-one solution, easily deploy virtual desktops for less than the cost of PCs and save 60% on VDI infrastructure costs. Try it free! http://p.sf.net/sfu/Citrix-VDIinabox _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users