| CI4 Models and Table Joins |
Over the past few hours, I've begun to wonder if it is more worthwhile to sacrifice space to increase speed.
Since a lot of the data is slow moving (a store building, for example, is unlikely to move), I wonder if it would be better to have two databases. Instead of having convoluted joins and recomputing the view each query, I'd have most of the data "precached" in CouchDB documents. I'd pull some basic data from the SQL Server, then find the correct "cache" document in CouchDB. |
| Messages In This Thread |
|
CI4 Models and Table Joins - by rockinmusicgv - 02-07-2022, 01:22 PM
RE: CI4 Models and Table Joins - by php_rocs - 02-07-2022, 02:50 PM
RE: CI4 Models and Table Joins - by rockinmusicgv - 02-07-2022, 03:57 PM
RE: CI4 Models and Table Joins - by rockinmusicgv - 02-07-2022, 10:34 PM
RE: CI4 Models and Table Joins - by php_rocs - 02-08-2022, 08:11 AM
RE: CI4 Models and Table Joins - by rockinmusicgv - 02-10-2022, 10:36 PM
RE: CI4 Models and Table Joins - by php_rocs - 02-11-2022, 07:29 AM
|
