Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-03-22 : 09:11:30
|
| jean-philippe writes "Hello,I would like to make a data cache (in asp) of a sql table. But to do that, I must have the date/time of last update for that table.-Example:if (date/time of last update) > (date/time of cache data) then read(data) in sql; change(date/time of cache date)=(date/time of last update); use(data) (vbScript for example) put(data) into cache;else read(data) in cache; use(data)end if How can I find (date/time of last table update)?-First, I try to find a 'last table update date' in sqlServer, but 'not found'-Second, I try to use a trigger (on update) on my table, and store the getdate() in a separate table. Ok, it works... but the performances are bad-So I try to store the getdate() in a global memory variable. But I can't find this sort of data in sqlServer. If you have an idea...-I also try to store the getdate() in a 'fast memory table with no transaction log'. But I can't find that.So, my real question is:-How can I temporary store global data with sqlServer. My data are not importants, and I search for a very fast system (no transaction log, no disk write... just in memory).?thanks" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-03-22 : 09:27:50
|
quote:
So, my real question is:-How can I temporary store global data with sqlServer. My data are not importants, and I search for a very fast system (no transaction log, no disk write... just in memory).?
Then you need to use something other than SQL Server. If your data is not important, it is definitely the wrong tool for you. |
 |
|
|
jean-philippe
Starting Member
1 Post |
Posted - 2002-03-22 : 17:20:20
|
quote:
quote:
So, my real question is:-How can I temporary store global data with sqlServer. My data are not importants, and I search for a very fast system (no transaction log, no disk write... just in memory).?
Then you need to use something other than SQL Server. If your data is not important, it is definitely the wrong tool for you.
thanks for your response, but it's not possible:-I said "not important": It's because I delete all the content of this table when my application restart (crash, shutdown....). So, no need of transaction.-I have a problem with an external tool: these datas must be calculate when a trigger fired (look at my first entire question).Jprjpr |
|
|
|
Nazim
A custom title
1408 Posts |
Posted - 2002-03-23 : 03:57:53
|
| you can use temporary tables too. Check for furthur information in BOL.-------------------------------------------------------------- |
|
|
|
|
|
|
|
|
caching data: date/time of last table update