Using PostgreSQL, I find myself frequently adding views (many w/ subqueries) as tables in the DCT. This is much better than struggling to duplicate using Clarion procedure views. While there is not any need to add a lot of keys & relationships w/ everything handled by PG, as the number of tables mo…

I think a few people have said some slight problems and having to define tables per module (template checkbox) around 600+ files

Sounds like retirement plans should kick in at 599. Wondering if there is any dependency on file size (# colums) and/or relations defined. Maybe a good Carl test. :upside_down_face:

I’ve seen a dictionary with 1200 tables, so I don’t think it’s an absolute table limit. However; [image] totalhip: I find myself frequently adding views (many w/ subqueries) as tables in the DCT. This is not necessarily a great idea, especially if it is bloating your dictionary. Each table …

[image] Bruce: This is not necessarily a great idea…Each table in your dictionary consumes resources (which takes some time) every time you start a thread. …(about 1 tenth of a second or so for each 300 tables). This is likely not an issue in a Desktop program, but for a web app it might become…

[image] totalhip: As a consequence, I have to wonder if every table for every thread is really necessary? Afterall, would it not be possible (with some inspection) to determine which tables can possibly be used on a given thread? This would be astonishingly difficult to accomplish. (I actuall…

[image] Bruce: Each table in your dictionary consumes resources (which takes some time) every time you start a thread. So the more tables you have the “slower” each thread starts To reduce Thread memory if I have an older version of a file I’ll uncheck the Threaded box in the DCT. The file co…

[image] Bruce: This would be astonishingly difficult to accomplish. (I actually spent some time thinking this through some years ago for performance reasons.) I appreciate the lengthy response. One primary consideration is whether TPS files need to be accommodated or not. For example, with SQ…

[image] CarlBarnes: To reduce Thread memory if I have an older version of a file I’ll uncheck the Threaded box in the DCT. The file conversion code only runs once and in a single thread. This suggests that if the table is only used in one place, and only in what is basically a hand-code proce…

[image] totalhip: For example, with SQL I wonder if a RelationManager object is even necessary? That’s an interesting question. Conceptually I can see removing the RelationManager as a possibility, although that would incur some number of changes to the shipping templates. The savings though…