Hi, I'm creating a website that's very search-oriented and I'd like to have
a table strictly for restaurants, that will contain the restaurant genre, location etc.
I want to do this because restaurants have certain columns that are special for them
and I want to create a mySQL index using these columns to optimize the searches.
My questions are:
1. are there ways to this without touching the core?
2. what are the implications of this regarding elgg updates, I've never done an elgg update
and don't know how it works, does it replace all the engine php files? so in case I edit one
of them so when I update it'll erase the changes I made?
Thanx in advance and any solutions are welcome, fiftyeight.
info@elgg.org
Security issues should be reported to security@elgg.org!
©2014 the Elgg Foundation
Elgg is a registered trademark of Thematic Networks.
Cover image by RaĆ¼l Utrera is used under Creative Commons license.
Icons by Flaticon and FontAwesome.
- Cash@costelloc

Cash - 0 likes
- Create a subclass of ElggObject and override the load, save, set, and get methods to save your custom metadata in your table. The downside to this is those fields would not be available to the elgg_get_entities_from_*() functions.
- Use an external index for those metadata fields - either custom or using an OS package like Sphinx
- Evan Winslow@ewinslow

Evan Winslow - 0 likes
- DhrupDeScoop@Dhrup2000

DhrupDeScoop - 0 likes
- DhrupDeScoop@Dhrup2000

DhrupDeScoop - 0 likes
- fiftyeight@fiftyeight

fiftyeight - 0 likes
You must log in to post replies.An Elgg upgrade copies over all the core files. You should not put in files in the engine directory or edit the files in there if you want to have smooth upgrades.
I believe it is possible to do this without changing the Elgg engine. Two possibilities:
I strongly recommend Cash's second suggestion of going with Sphinx for searching.
.
.
Hi, I've been doing some reading, I'm still reading up on sphinx but I also ran into MySQL views which I wasn't familiar with, do you think I can use views to do this?
EDIT: I ead some more and it seems you can't create indexes for views, so it's back to reading on sphinx