1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2000
    Rep Power
    Is there any way of making MySQL index a field for more that 256 characters? We have about 2K of index-required data that needs to be lightening fast and we cannot find a way to do this. I have even tried changing the table type, but even this has not worked.

    Help please!
  2. #2
  3. No Profile Picture
    Apprentice Deity
    Devshed Loyal (3000 - 3499 posts)

    Join Date
    Jul 1999
    Niagara Falls (On the wrong side of the gorge)
    Rep Power
    Nope, you can't index BLOB and TEXT types. Not that it would likely be much help. When using a where clause on a large field, you would probably use a LIKE comparison using wildcards. Indexes can only utilitize a LIKE comparison if there is NO wildcard in the first character of the match, even on CHAR and VARCHAR types. Not likely when comparing a large text field.

    The only solution that comes to mind is a table of keywords that you could extract from the large files, filtering out common words (and, but, if, the, etc.)

    That would be a large table and preclude phrase searching, but would prevent using LIKE and wildcards to take advantage of indexing.

Similar Threads

  1. ADO streams and binary data held in a MySQL database blob field
    By mrbryanejones in forum ASP Programming
    Replies: 2
    Last Post: August 18th, 2004, 08:15 AM
  2. Replies: 1
    Last Post: February 6th, 2004, 05:53 AM
  3. Replies: 2
    Last Post: May 12th, 2003, 03:04 AM
  4. Inserting a textarea field into a mysql database
    By Scurvy in forum PHP Development
    Replies: 2
    Last Post: April 7th, 2003, 02:36 PM
  5. mysql fulltext index
    By subwiz in forum MySQL Help
    Replies: 1
    Last Post: October 23rd, 2001, 02:36 AM

IMN logo majestic logo threadwatch logo seochat tools logo