Обсуждение: Temporary Views or tables

Поиск
Список
Период
Сортировка

Temporary Views or tables

От
Sumeet
Дата:
Hi all,<br /><br />I'm trying to use temporary views in my application, before i proceed and go ahead for creating the
temoraryview i would like more abt it.<br />1) when is the temporary view automatically deleted. Is it after we close
theconnection or when the session ends....for.e.g  my website doesnt <br />  use a persistant connection to my postgres
serverand it queries and then disconnects from the db server. In one of such connections...if i create a temporary
view<br/>  will this temp view be visible to me after multiple disconnects and connects ???? <br />2) Is the view
approachfaster then creating temporary tables??? (and the same question as abovew for temp. tables.)<br />3) If there
aremultiple users who connect to my website at the same time and create temporary views or tables with the same name
wouldthere be any overlapping or such??? <br /><br />-- <br />Thanks,<br />Sumeet.<br />