On Mon, Jan 15, 2001 at 11:41:39AM -0800, Arthur Radulescu wrote:
> Hi!
>
> I have 2 questions!
>
> 1.What is more eficient to keep some images into a table or to keep
> 1.their names in the table and images separated in a directory?
If your main concern is effiency, keep the images in the filesystem.
> 2.How can I join to big tables and verify if there are any duplicates
> (i have tried just to view the data from those tables with something
> like "select data1,data2 from table1, table2 where table1.data1 !=
> table2.data2" ... and MySQL is out of memory) ?
Do you understand *why* MySQL runs out of memory attempting to run
that query? You're likely asking it for billions of rows!
You might try
select data1,data2 from table1, table2 where table1.data1 != tbl.data2
If you *do* get any rows, there are duplicates. And you'll know
exactly which values are duplicated.
Jeremy
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 328-7878 Fax: (408) 530-5454
Cell: (408) 439-9951
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
