[MonetDB-users] Extra Tables and performance
I was wondering if I added referential integrity with a foreign keys will slow down a query. I know the loading will take longer but would MonetDB be much slower if I was doing a query? TIA
Mag Gam wrote:
I was wondering if I added referential integrity with a foreign keys will slow down a query. I know the loading will take longer but would MonetDB be much slower if I was doing a query?
TIA
------------------------------------------------------------------------------ The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your production scanning environment may not be a perfect world - but thanks to Kodak, there's a perfect scanner to get the job done! With the NEW KODAK i700 Series Scanner you'll get full speed at 300 dpi even with all image processing features enabled. http://p.sf.net/sfu/kodak-com _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users (single) foreign key joins are fast. they are implemented with join indices.
Thankyou again
On Sun, May 10, 2009 at 2:37 AM, Martin Kersten
Mag Gam wrote:
I was wondering if I added referential integrity with a foreign keys will slow down a query. I know the loading will take longer but would MonetDB be much slower if I was doing a query?
TIA
------------------------------------------------------------------------------ The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your production scanning environment may not be a perfect world - but thanks to Kodak, there's a perfect scanner to get the job done! With the NEW KODAK i700 Series Scanner you'll get full speed at 300 dpi even with all image processing features enabled. http://p.sf.net/sfu/kodak-com _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users (single) foreign key joins are fast. they are implemented with join indices.
------------------------------------------------------------------------------ The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your production scanning environment may not be a perfect world - but thanks to Kodak, there's a perfect scanner to get the job done! With the NEW KODAK i700 Series Scanner you'll get full speed at 300 dpi even with all image processing features enabled. http://p.sf.net/sfu/kodak-com _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
participants (2)
-
Mag Gam -
Martin Kersten