Hi all
Which of these two tables wiil yield the best performance in a table
with about 6 million entries (for rapid selects on either field):
table_using_char
field1 char(50),
field2 char(50),
filed 3 char(50),
separate unique indexes on all 3 fields
table_using_varchar
field1 varchar(50),
f
declare the two fields you want unique as such? unique index.
alec
Kory Wheatley wrote:
I have a database called accountcreation, and I want to setup a table called accountinfo.
This table will require that two out of the three fields need to be "UNIQUE",
I don't want duplications in these
I would put the pdf as a regular file on the hd, and store the path to
it in the db.
Meta data could be things like the size of the pdf, author, owner,
number of pages etc.
Storing binary data from pdf:s or images or any other common binary
format is generally not a good idea.
Alec
Ed wrote
n Wednesday 07 March 2007 21:26, Alexander Lind wrote:
I would put the pdf as a regular file on the hd, and store the path to
it in the db.
Meta data could be things like the size of the pdf, author, owner,
number of pages etc.
Storing binary data from pdf:s or images or any other common binary
Kevin Hunter wrote:
Grrr. All you lazy top-posters! ;) It seems to me that a case can
be legitimately made for both methods of handling BLOBs. On the one
hand, where speed and/or efficiency (on many different levels) are the
top priorities, it'd be good to keep the DB as trim as possible.
