On 3/20/24 10:51, Celia McInnis wrote:
The view is being used in some web query software that multiple people
will be accessing and the contents of the view depend on what the
person is querying, so I think that temporary views or tables are a
good idea. I change to non-temporary views or tables (in a test
version of the software which is not web-crawl-able) when I'm trying
to debug things, and I guess I have to be careful to clean those up
when I switch back to the temporary tables/views.
Are multiple people seeing the same dataset, or is each getting their
own data albeit of the same structure? What mechanism populates the
web-page? I ask because I think you might not need to make database
structures at all.
