From: Anthony Cooke <[EMAIL PROTECTED]>
Date: Mon, 15 Jan 2001 10:33:05 -0400
To: Arthur Radulescu <[EMAIL PROTECTED]>
Subject: Re: 2 questions!
Two answers!
1. Answer: Read "Chapter 12.6: Other optimization tips". In essence let
the file system cache image files, store only the file name.
2. Answer: Use left join to join on equally matching keys, group by key,
count records in each group, select groups with a count over two. Selecting
table1.data1 != table2.data2 would give you a very, very large result
because for each record you match it against all the other records in the
table.
Saludos,
Anthony
> From: "Arthur Radulescu" <[EMAIL PROTECTED]>
> Date: Mon, 15 Jan 2001 11:41:39 -0800
> To: <[EMAIL PROTECTED]>
> Subject: 2 questions!
>
> Hi!
>
> I have 2 questions!
>
> 1.What is more eficient to keep some images into a table or to keep their
> names in the table and images separated in a directory?
>
> 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) ?
>
---------------------------------------------------------------------
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
