FireFox! The PHP Forum Loans and Credit
Panama Web Design for Hire Free Insurance Quotes!
Web Hosting Advertise Here $10 a Month Designer Children
Never Pay Taxes Again HGH Domain name registration
Web Hosting and Dedicated Servers Insurance Affordable web-hosting


Home • Watched Topics • Register • Search• Directory
FAQ • Memberlist • Usergroups • Log in• Stores • Items • Bank
Google

ANNOUNCEMENT

THE PHP FORUM.NET IS HIRING MODERATORS.
PLEASE SEND A PRIVATE MESSAGE TO PRATAMISHUS IF YOU WANT TO EARN SOME EXTRA CASH (Registered users only).

Forum Index » Friendly PHP Lounge for Free PHP Help and PHP Discussion » Mysql Full Text Searc or Indexing

The time now is Mon Oct 06, 2008 1:34 pm
View previous topic | View next topic
Reply to topic Page 1 of 1
Mysql Full Text Searc or Indexing
Message  
dharprog
Developer
Joined: 08 Oct 2006
Posts: 55

in.gif

875 Cash

Reply with quote
Post Mysql Full Text Searc or Indexing 
Hi

Can anybody please tell me which is the best in real time Searching:

Either: 1) Mysql Full Text Search or 2) Index Searching.

Which is the better one to implement and what are the advantages and disadvantages?

Thanks and Regards,
DharProg
Tue Apr 08, 2008 11:42 pm View user's profile Send private message
pratamishus
Site Admin
Joined: 05 Sep 2006
Posts: 587
Location: Tashkent
uz.gif

1552 Cash

Reply with quote
Post  
The best way to make search is index searching. This is much faster than full text search. The index searching helps to store the data in a needed order which increases search performance, but the disadvantage is that the database size will increase and insert, update and delete operations will increase the load on dbms.

Regards,
Pratamishus


_________________
www.eb-downloads.com
FREE E-BOOKS DOWNLOADS.
Sun May 11, 2008 6:50 am View user's profile Send private message Send e-mail Visit poster's website Yahoo Messenger
Display posts from previous:

Forum Index » Friendly PHP Lounge for Free PHP Help and PHP Discussion » Mysql Full Text Searc or Indexing

The time now is Mon Oct 06, 2008 1:34 pm | All times are GMT - 6 Hours
 
Reply to topic Page 1 of 1
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
  



Google

FireFox! The PHP Forum Loans and Credit
Panama Web Design for Hire Free Insurance Quotes!
Web Hosting Advertise Here $10 a Month Designer Children
Never Pay Taxes Again HGH Domain name registration
Web Hosting and Dedicated Servers Insurance Affordable web-hosting


Web Design by PlatinumShore.com & Web Hosting by TradeWebHosting.com