|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
|
Get inside! Sample the range of functionality easily built with JMSL Library for Time Series Data Analysis, Heat Maps, Portfolio Optimization, Monte Carlo Simulation, Stock Price Charting and more. Download Now! |
|
#1
|
|||
|
|||
|
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
|
|||
|
|||
|
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. |
![]() |
| Viewing: Dev Shed Forums > Databases > MySQL Help > MySQL Field Index Limits |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|