Has anyone tried to write to an In-Memory table such as a PostGIS temporary table?
Question
Has anyone tried to write to an In-Memory table such as a PostGIS temporary table?
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
+59- Safer
For what it's worth, I've tried this in a SQLExecutor transformer before, like...
FME_SQL_DELIMITER ;
DROP TABLE imark_temp_table;
CREATE TEMPORARY TABLE imark_temp_table (a varchar(100),b varchar(100));
INSERT INTO imark_temp_table (a,b) values ('xxxx','yyyy');
SELECT COUNT(*) AS FeatureCount FROM imark_temp_table;But it only exists during that SQLExecutor. If I tack another SQLExecutor on afterwards and repeat the SELECT COUNT(*) command, it tells me imark_temp_table doesn't exist.
So I guess it works, but I'd say the uses are fairly limited.
I gathered that postgresql temporary tables are created in the buffer. So, I wonder whether the use of temporary tables can help speed up the process.
Any clue?