Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

MySQL FullText Index Search


AXM

Recommended Posts

Posted

Anyone out there try utilitizing MySQL FullText index with their OSC? Looks pretty interesting to me.

 

I'm still trying to adapt OSC to work with full boolean searches including the nots...but kind of placed the efforts on pause for the moment. But is there anyone out there attempt (or became successful with) utilizing MySQL fulltext index with their OSCommerce? With the ability to sort listings based on a "best match algorithm" and possibly a significant speed increase over a table scan... it looks interesting. I don't really like how large the index file was though. If I remember correct, the index file was double the size of the datafile *shrug*.

 

Just curious.

I ♥ PHP/MYSQL/CSS

Posted

Haven't tried it since you can't use it with InnoDB tables.

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...