| # |
Jul 10th 2018, 09:29 |
 james.phillips |
I get you |
| # |
Jul 10th 2018, 09:29 |
josbeir |
it doesn't matter if that stuff has duplicates |
| # |
Jul 10th 2018, 09:28 |
josbeir |
with ES you can just save all that stuff in 1 document |
| # |
Jul 10th 2018, 09:28 |
josbeir |
basically, in sql you have a primary record with all associations you need joined, that result you then use in your app |
| # |
Jul 10th 2018, 09:28 |
james.phillips |
ok thanks |
| # |
Jul 10th 2018, 09:28 |
josbeir |
read up on database denormalization |
| # |
Jul 10th 2018, 09:27 |
josbeir |
mean* |
| # |
Jul 10th 2018, 09:27 |
josbeir |
i know what you mena |
| # |
Jul 10th 2018, 09:27 |
james.phillips |
ahh ive thought in mysql terms for 20 years lol |
| # |
Jul 10th 2018, 09:27 |
josbeir |
think in nosql |
| # |
Jul 10th 2018, 09:27 |
josbeir |
don't think in database/sql terms |
| # |
Jul 10th 2018, 09:27 |
josbeir |
you should denormalize your documents in ES |
| # |
Jul 10th 2018, 09:26 |
josbeir |
well.. there is the catch |
| # |
Jul 10th 2018, 09:26 |
james.phillips |
So I have an index class for each model I want to search via ES? |
| # |
Jul 10th 2018, 09:26 |
josbeir |
make a cron job of it or something |
| # |
Jul 10th 2018, 09:26 |
josbeir |
shell script is probably the simplest |
| # |
Jul 10th 2018, 09:26 |
josbeir |
but you need to read up on the cake event system |
| # |
Jul 10th 2018, 09:25 |
josbeir |
its not that hard |
| # |
Jul 10th 2018, 09:25 |
neon1024 |
It isn’t. |
| # |
Jul 10th 2018, 09:25 |
james.phillips |
sounds good. doesnt sound easy thou.... |
| # |
Jul 10th 2018, 09:25 |
josbeir |
if you want to do it real time |
| # |
Jul 10th 2018, 09:25 |
josbeir |
you could also use cake events to keep everything in sync |
| # |
Jul 10th 2018, 09:25 |
james.phillips |
and push it all back? |
| # |
Jul 10th 2018, 09:25 |
neon1024 |
..and all your data |
| # |
Jul 10th 2018, 09:24 |
neon1024 |
Just remember that if you change your data types, you have to drop your index |
| # |
Jul 10th 2018, 09:24 |
james.phillips |
so before save push data to ES ? |
| # |
Jul 10th 2018, 09:24 |
josbeir |
or just use the index as your primary datasource but that should be considered carefully |
| # |
Jul 10th 2018, 09:24 |
neon1024 |
A shell which ingests MySQL data to ES is a good idea |
| # |
Jul 10th 2018, 09:24 |
james.phillips |
yep.... |
| # |
Jul 10th 2018, 09:24 |
josbeir |
you could write a command that syncs the data from those tables to ES |
| # |
Jul 10th 2018, 09:24 |
josbeir |
no prob, you want to make your tables searchable right? |
| # |
Jul 10th 2018, 09:23 |
james.phillips |
btw thanks |
| # |
Jul 10th 2018, 09:23 |
james.phillips |
and a eventsIndex class in cake |
| # |
Jul 10th 2018, 09:23 |
james.phillips |
working the other way.. I have an events table entity and table in Cake... I need a events index in ES? |
| # |
Jul 10th 2018, 09:22 |
james.phillips |
Sorry i'm being thick.... |
| # |
Jul 10th 2018, 09:22 |
josbeir |
so take you have an index in ES 'products', you would have a class ProductsIndex |
| # |
Jul 10th 2018, 09:22 |
neon1024 |
You can’t save stuff into ES without an index to save to |
| # |
Jul 10th 2018, 09:22 |
josbeir |
well.. the index ORM class that will talk to the ES index |
| # |
Jul 10th 2018, 09:22 |
james.phillips |
the index within ES? |
| # |
Jul 10th 2018, 09:21 |
josbeir |
the name of your index ? |
| # |
Jul 10th 2018, 09:21 |
james.phillips |
$index = IndexRegistry::get('Foo'); what is Foo ? |