| # |
Sep 7th 2019, 01:23 |
slackebot |
instance, $connectionOne could query table 1, $connectionTwo could query table 2, etc but a single query cannot span multiple connections unless you setup federated connections within the database server or a query proxy server. |
| # |
Sep 7th 2019, 01:23 |
 jimbo2150 |
@itmpls I do not believe it is possible to have separate connections within a single query. Also, tables are not tied to connections. Your $table variables are likely query objects and you are setting the same connection on each. If you need separate connections you will need to either copy the connection into new connections or duplicate the connection in your app config but you cannot include separate connections in a single query. For |
| # |
Sep 7th 2019, 00:34 |
itmpls |
checked for typos |
| # |
Sep 7th 2019, 00:34 |
itmpls |
but table2 is? |
| # |
Sep 7th 2019, 00:33 |
itmpls |
I'm doing something like $table1->setConnection('foo'); $table2->setConnection('foo'); $table3->setConnection('foo'); $results = $table1->contain(['table2', 'table3']); and table3 is not getting switched to that connection |
| # |
Sep 7th 2019, 00:33 |
itmpls |
how can I guarantee that my tables that are being contained have my (new) connection set? |
| # |
Sep 6th 2019, 20:28 |
alexdd55976 |
man, that was fun.. |
| # |
Sep 6th 2019, 20:27 |
alexdd55976 |
i think that would add another 200k lines.. maybe even more |
| # |
Sep 6th 2019, 20:27 |
alexdd55976 |
we created a fork and added extensive product details to generate product catalogs with 10k products for a welding company. |
| # |
Sep 6th 2019, 20:26 |
alexdd55976 |
fun to see how much work we spend and thats still running |
| # |
Sep 6th 2019, 20:25 |
ricksaccous |
yeah that's a whole lot |
| # |
Sep 6th 2019, 20:25 |
alexdd55976 |
but thats a lot i think |
| # |
Sep 6th 2019, 20:25 |
alexdd55976 |
so after all.. statistics say: 800k lines of code in app folder |
| # |
Sep 6th 2019, 20:24 |
ricksaccous |
oh ok |
| # |
Sep 6th 2019, 20:23 |
alexdd55976 |
corrected.. we used a couple of external libs, that took a loot lines of codes, like pdf and srudd |
| # |
Sep 6th 2019, 20:23 |
ricksaccous |
:0 |
| # |
Sep 6th 2019, 20:22 |
alexdd55976 |
2.3 million lines of code |
| # |
Sep 6th 2019, 20:22 |
alexdd55976 |
wow |
| # |
Sep 6th 2019, 20:22 |
ricksaccous |
but that's awesome that you have something like that chugging along successfully |
| # |
Sep 6th 2019, 20:21 |
ricksaccous |
hopefully that's just one lib you can upgrade/update |
| # |
Sep 6th 2019, 20:20 |
alexdd55976 |
but it has a ERP integrated :) |
| # |
Sep 6th 2019, 20:20 |
alexdd55976 |
almost none |
| # |
Sep 6th 2019, 20:18 |
ricksaccous |
do you have a lot of JS magic? |
| # |
Sep 6th 2019, 20:18 |
ricksaccous |
lol |
| # |
Sep 6th 2019, 20:18 |
ricksaccous |
pretty much a rewrite |
| # |
Sep 6th 2019, 20:18 |
ricksaccous |
might not be too bad, but it might also be bad |
| # |
Sep 6th 2019, 20:18 |
ricksaccous |
depending on how big it is |
| # |
Sep 6th 2019, 20:17 |
alexdd55976 |
:exploding_head: |
| # |
Sep 6th 2019, 20:17 |
alexdd55976 |
migrate to 4.0 |
| # |
Sep 6th 2019, 20:17 |
alexdd55976 |
LOL |
| # |
Sep 6th 2019, 20:17 |
ricksaccous |
just so you can upgrade php version |
| # |
Sep 6th 2019, 20:17 |
ricksaccous |
lol |
| # |
Sep 6th 2019, 20:17 |
ricksaccous |
you should upgrade one day |
| # |
Sep 6th 2019, 20:17 |
ricksaccous |
dang dude that's awesome |
| # |
Sep 6th 2019, 20:15 |
alexdd55976 |
cake1.3 is still a beast |
| # |
Sep 6th 2019, 20:15 |
alexdd55976 |
12k products |
| # |
Sep 6th 2019, 20:15 |
alexdd55976 |
10k customers |
| # |
Sep 6th 2019, 20:14 |
alexdd55976 |
almost 4 million orders, stills super fast |
| # |
Sep 6th 2019, 20:14 |
alexdd55976 |
i am seriously happy with that shop |
| # |
Sep 6th 2019, 20:13 |
alexdd55976 |
yes |
| # |
Sep 6th 2019, 20:13 |
ricksaccous |
i mean exists |