I am trying to set an index on a field in my table, but am getting the
following error:
BLOB column 'ReadBy' used in key specification without a key length
The fieldtype is blob, though I get the same error whether blob or text, or
the medium and long versions of each. My first
You can't use that column type as an index because it's variable length.
Make it a varchar or something that's definite to index it.
-Micah
On 02/09/2007 03:56 PM, John Pillion wrote:
I am trying to set an index on a field in my table, but am getting the
following error:
BLOB column
as to what type to use
that wouldn't be variable length, but be able to store strings/values of
that size?
Thanks!
John
-Original Message-
From: Micah Stevens [mailto:[EMAIL PROTECTED]
Sent: Friday, February 09, 2007 6:29 PM
To: John Pillion
Cc: php-db@lists.php.net
Subject: Re: [PHP-DB] indexing
to use
that wouldn't be variable length, but be able to store strings/values of
that size?
Thanks!
John
-Original Message-
From: Micah Stevens [mailto:[EMAIL PROTECTED]
Sent: Friday, February 09, 2007 6:29 PM
To: John Pillion
Cc: php-db@lists.php.net
Subject: Re: [PHP-DB] indexing
(I know this is more of a mySQL question than PHP, but allow me this one if
you would...)
In MySQL, is there any difference between creating an index at table
creation time, and creating an index on an existing table? Does an index
created on an existing table re-index itself after each
Index is always re-indexing itself on INSERT/UPDATE. Roughly, I don't
think there is any difference in when you create an index before or
after table is populated.
--
Maxim Maletsky
[EMAIL PROTECTED]
Jason Vincent [EMAIL PROTECTED] wrote... :
(I know this is more of a mySQL question than
Except when you have a million records, which may take a few seconds to
build. :-)
Marco
-
php|architect -- The Monthly Magazine For PHP Professionals
Come visit us on the web at http://www.phparch.com!
On Fri, 2002-11-08 at 11:12, Maxim Maletsky wrote:
Index is always
In MySQL, is there any difference between creating an index at table
creation time, and creating an index on an existing table? Does an
index
created on an existing table re-index itself after each insert/update,
or
does it only index itself once - when you create the index?
In the end, it's
But, remember - you don't rebuild completely an index - you rather add
to it.
So, there are three scenarios:
1. Q: You create the table to then send into it lots of data row per row
A: create the table first, then build an idex on it once.
2. Q: You have to constantly be adding the data
Hi there,
I am wondering if it would be anyhow possible to make a search on a
textfield faster. Right now the table contains 294000 entries and takes
about 40 MB of space. Is there a way to apply a index with a resonable
amount of disk space? I am also not so sure if I should use text or
Hi all,
More of a database question here, my apologies:
I've been doing some reading on indexes but I thought I should get an
experienced persons input. My question is about Over Indexing.
I have a MySQL MyISAM table that stores inventory transactions, in, out
etc. I store numeric fields that
replies below:
""M. Verheijen"" [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
Dear reader,
A newbie mysql/php-question here! I've filled a mysql-database with about
1600 records. All these records contain items which
are on sale on a website. Every row contains
Columns used in the WHERE clause is the good identifier for which columns to
index. You don't want to index every column you select.
Typically adding indexes decreases insert performance. The more indexes the
slower inserts operate, because the indexes also must be updated.
Adding an index to
Dear reader,
A newbie mysql/php-question here! I've filled a mysql-database with about 1600
records. All these records contain items which
are on sale on a website. Every row contains an integer defining the category to which
a item belongs.
At the left of the website there are buttons linked
14 matches
Mail list logo