Quote:When search on long text on table have 40 milion rows it is very slow so what I do ?
When will you learn 'Database Design' properly ? As you have been told many times.
Database design is much more than table creation.
In a technical book, when you search something, you can read the whole book, or go to the index at the end and select pages matching a keyword.
Same techniques exist with databases and choosing how to combine them with the flat database is 'database design', and the design also depend on the usage of the database.
So I can tell you to use indexes, but if you don't understand how to use them, chances are that you will get a mess.