![]() | |
![]() |
| | Thread Tools | Display Modes |
#1
| |||
| |||
|
#2
| |||
| |||
|
|
Does anyone know where I can find informations about Cache policy, Cache Ratio ? What is the meaning of the numbers like 7 or 5 for cache policy?. In the MS doc is written [reserverd] ![]() My problem is that I have an aplcation wich is changing the fact table then is triggering an dts to update the cubes and when is finished is reading the data. The problem is that the data that is readed is the old one. If I wait for 5-10sec and then I read again, the data is the new, correct one. The dts are executed syncron, so I wait for the DTS to be finished. |
#3
| |||
| |||
|
|
try to change the "Auto Synch Period" option in the connection string. http://msdn.microsoft.com/library/de...pgref_3yex.asp "Radu Colceriu" <radu_colceriu (AT) hotmail (DOT) com> wrote in message news:uc7F4gFtFHA.1132 (AT) TK2MSFTNGP10 (DOT) phx.gbl... Does anyone know where I can find informations about Cache policy, Cache Ratio ? What is the meaning of the numbers like 7 or 5 for cache policy?. In the MS doc is written [reserverd] ![]() My problem is that I have an aplcation wich is changing the fact table then is triggering an dts to update the cubes and when is finished is reading the data. The problem is that the data that is readed is the old one. If I wait for 5-10sec and then I read again, the data is the new, correct one. The dts are executed syncron, so I wait for the DTS to be finished. |
#4
| |||
| |||
|
|
Cache Ratio Property Reserved for future use ![]() "Jéjé" <willgart_A_ (AT) hotmail_A_ (DOT) com> schrieb im Newsbeitrag news:eNCzcHHtFHA.236 (AT) TK2MSFTNGP11 (DOT) phx.gbl... try to change the "Auto Synch Period" option in the connection string. http://msdn.microsoft.com/library/de...pgref_3yex.asp "Radu Colceriu" <radu_colceriu (AT) hotmail (DOT) com> wrote in message news:uc7F4gFtFHA.1132 (AT) TK2MSFTNGP10 (DOT) phx.gbl... Does anyone know where I can find informations about Cache policy, Cache Ratio ? What is the meaning of the numbers like 7 or 5 for cache policy?. In the MS doc is written [reserverd] ![]() My problem is that I have an aplcation wich is changing the fact table then is triggering an dts to update the cubes and when is finished is reading the data. The problem is that the data that is readed is the old one. If I wait for 5-10sec and then I read again, the data is the new, correct one. The dts are executed syncron, so I wait for the DTS to be finished. |
#5
| |||
| |||
|
|
oups... http://msdn.microsoft.com/library/en...asp?frame=true "Radu Colceriu" <radu_colceriu (AT) hotmail (DOT) com> wrote in message news:OfS2DLHtFHA.3452 (AT) TK2MSFTNGP14 (DOT) phx.gbl... Cache Ratio Property Reserved for future use ![]() "Jéjé" <willgart_A_ (AT) hotmail_A_ (DOT) com> schrieb im Newsbeitrag news:eNCzcHHtFHA.236 (AT) TK2MSFTNGP11 (DOT) phx.gbl... try to change the "Auto Synch Period" option in the connection string. http://msdn.microsoft.com/library/de...pgref_3yex.asp "Radu Colceriu" <radu_colceriu (AT) hotmail (DOT) com> wrote in message news:uc7F4gFtFHA.1132 (AT) TK2MSFTNGP10 (DOT) phx.gbl... Does anyone know where I can find informations about Cache policy, Cache Ratio ? What is the meaning of the numbers like 7 or 5 for cache policy?. In the MS doc is written [reserverd] ![]() My problem is that I have an aplcation wich is changing the fact table then is triggering an dts to update the cubes and when is finished is reading the data. The problem is that the data that is readed is the old one. If I wait for 5-10sec and then I read again, the data is the new, correct one. The dts are executed syncron, so I wait for the DTS to be finished. |
#6
| |||
| |||
|
|
thanks, unfortunatelly i use a tool that doesn't allow me to change/alter the connection string. it gives me an interface only 4 params: Cache policy, cache ratio, execution location, isolation mode. I can't find any doc about what cache ratio and cahce policy parameters means. I've seen a lot of people using it. "Jéjé" <willgart_A_ (AT) hotmail_A_ (DOT) com> schrieb im Newsbeitrag news:OClarTTtFHA.3316 (AT) TK2MSFTNGP12 (DOT) phx.gbl... oups... http://msdn.microsoft.com/library/en...asp?frame=true "Radu Colceriu" <radu_colceriu (AT) hotmail (DOT) com> wrote in message news:OfS2DLHtFHA.3452 (AT) TK2MSFTNGP14 (DOT) phx.gbl... Cache Ratio Property Reserved for future use ![]() "Jéjé" <willgart_A_ (AT) hotmail_A_ (DOT) com> schrieb im Newsbeitrag news:eNCzcHHtFHA.236 (AT) TK2MSFTNGP11 (DOT) phx.gbl... try to change the "Auto Synch Period" option in the connection string. http://msdn.microsoft.com/library/de...pgref_3yex.asp "Radu Colceriu" <radu_colceriu (AT) hotmail (DOT) com> wrote in message news:uc7F4gFtFHA.1132 (AT) TK2MSFTNGP10 (DOT) phx.gbl... Does anyone know where I can find informations about Cache policy, Cache Ratio ? What is the meaning of the numbers like 7 or 5 for cache policy?. In the MS doc is written [reserverd] ![]() My problem is that I have an aplcation wich is changing the fact table then is triggering an dts to update the cubes and when is finished is reading the data. The problem is that the data that is readed is the old one. If I wait for 5-10sec and then I read again, the data is the new, correct one. The dts are executed syncron, so I wait for the DTS to be finished. |
![]() |
| Thread Tools | |
| Display Modes | |
| |