|
-
Aug 3rd, 2007, 12:56 PM
#1
Thread Starter
Addicted Member
Best way to pull large amounts of data MYSQL
i have two tables as follows using mysql
product features
-product_id int(11)
-feature_value
product_description
-product_id int(11)
-description_value
i need to be able to search tese two for all product id;s that have the keyword i specify in them. just for a simple search on our website. the issue is there are 50k+ records in each and it takes forever to run the sql statement
im trying fulltext indexes but im having trouble joining the two its still takes a long time to run. does anyone know of a good way to pull text from a database of this size relativly fast?
thanks in advance
-JLR
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|