<p class="MsoPlainText" style="margin: 0cm 0cm 0pt;"><font face="Consolas" size="3">Lze ve FB definovat tabulku,ktera je pouze v RAM, tedy nikdy se nezapisuje na disk?<br />
Jak jsem rikal, potreboval bych jednak omezit zapisy na max 1x za hodinu pricemz se zaroven 80% dotazu bude tykat prave nejcerstvejsich dat tak by i z logiky veci meli byt v RAM a nezdrzovat provoz ctenim z CF.<br />
Nebo jak jinak tohoto stavu dosahnout?<br />
<br />
Pavel<br />
<br />
P.S. Kde proboha jsou slibovane PRAM a proc se nam porad cpou ty nesmyslne FLash? <img src="http://i0.cz/6/gm526/emotions/smiley-smile.gif" border="0" alt="Smile" title="Smile" /><br />
<br />
<br />
>Delam s FB pod windows, ale sposta veci je spolecnych.</font></p>
<p class="MsoPlainText" style="margin: 0cm 0cm 0pt;"><font face="Consolas" size="3"> </font></p>
<p class="MsoPlainText" style="margin: 0cm 0cm 0pt;"><font face="Consolas" size="3">Zapisy na disk se daji omezit v konfiguracnim souboru tak, ze se jednak vypne forced writes (nastaveni DB) a zaroven se nastavi flush na nejakou rozumnou dobu (rekneme 10 minut).</font></p>
<p class="MsoPlainText" style="margin: 0cm 0cm 0pt;"><font face="Consolas" size="3">Operacni system ale muze data zapsat i drive, ale to uz je otazka na nekoho linux komunity.</font></p>
<p class="MsoPlainText" style="margin: 0cm 0cm 0pt;"><font face="Consolas" size="3">Tim se da zabranit zapisu do DB pri zahajeni kazde transakce.</font></p>
<p class="MsoPlainText" style="margin: 0cm 0cm 0pt;"><font face="Consolas" size="3"> </font></p>
<p class="MsoPlainText" style="margin: 0cm 0cm 0pt;"><font face="Consolas" size="3">Pokud budete mit DB jen pro cteni, tak se do prevest do rezimu READ ONLY, pak se pouze cte (urceno pro DB na CDROM).</font></p>
<p class="MsoPlainText" style="margin: 0cm 0cm 0pt;"><font face="Consolas" size="3"> </font></p>
<p class="MsoPlainText" style="margin: 0cm 0cm 0pt;"><font face="Consolas" size="3">Jeste poznamka, FB instalovat jako superserver.</font></p>
<p class="MsoPlainText" style="margin: 0cm 0cm 0pt;"><font face="Consolas" size="3">Bude pak poslouchat na portu 3050 a pres TCP se s nim da v pohode pracovat prakticky z jakehokoliv jazyka.</font></p>
<p class="MsoPlainText" style="margin: 0cm 0cm 0pt;"><font face="Consolas" size="3"> </font></p>
<p class="MsoPlainText" style="margin: 0cm 0cm 0pt;"><font face="Consolas" size="3">Slavek</font></p>
<p class="MsoPlainText" style="margin: 0cm 0cm 0pt;"><font face="Consolas" size="3"> </font></p>
<p class="MsoPlainText" style="margin: 0cm 0cm 0pt;"><font face="Consolas" size="3">Ing. Slavomir Skopalik</font></p>
<p class="MsoPlainText" style="margin: 0cm 0cm 0pt;"><font face="Consolas" size="3">Jednatel spolecnosti</font></p>
<p class="MsoPlainText" style="margin: 0cm 0cm 0pt;"><font face="Consolas" size="3">Elekt Labs s.r.o.</font></p>
<p class="MsoPlainText" style="margin: 0cm 0cm 0pt;"><font face="Consolas" size="3">Chaloupky 158</font></p>
<p class="MsoPlainText" style="margin: 0cm 0cm 0pt;"><font face="Consolas" size="3">783 72 Velky Tynec</font></p>
<p class="MsoPlainText" style="margin: 0cm 0cm 0pt;"><font face="Consolas" size="3">Czech Republic</font></p>
<p class="MsoPlainText" style="margin: 0cm 0cm 0pt;"><font face="Consolas" size="3">--------------------------------------------</font></p>
<p class="MsoPlainText" style="margin: 0cm 0cm 0pt;"><font face="Consolas" size="3">Mobil: +420 724 207 851</font></p>
<p class="MsoPlainText" style="margin: 0cm 0cm 0pt;"><font face="Consolas" size="3">icq:199 118 333</font></p>
<p class="MsoPlainText" style="margin: 0cm 0cm 0pt;"><font face="Consolas" size="3">e-mail:skopalik@elektlabs.cz</font></p>
<p class="MsoPlainText" style="margin: 0cm 0cm 0pt;"><a href="http://www.elektlabs.cz/"><font face="Consolas" size="3" color="#0000ff">http://www.elektlabs.cz</font></a></p>
<p class="MsoPlainText" style="margin: 0cm 0cm 0pt;"><font face="Consolas" size="3"> </font></p>
<p class="MsoPlainText" style="margin: 0cm 0cm 0pt;"><font face="Consolas" size="3"> </font></p>
<p class="MsoPlainText" style="margin: 0cm 0cm 0pt;"><font face="Consolas" size="3">> </font></p>
<p class="MsoPlainText" style="margin: 0cm 0cm 0pt;"><font face="Consolas" size="3">> Vyhrabal jsem nejakou desku s AMD Geode, jde k ni propojit jen CF, </font></p>
<p class="MsoPlainText" style="margin: 0cm 0cm 0pt;"><font face="Consolas" size="3">> chtel bych na to nahrat debian a provozovat SQL server pro sber dat.</font></p>
<p class="MsoPlainText" style="margin: 0cm 0cm 0pt;"><font face="Consolas" size="3">> </font></p>
<p class="MsoPlainText" style="margin: 0cm 0cm 0pt;"><font face="Consolas" size="3">> U toho Debianu nevim jak zacit, tedy jak ho nainstalovat na CF, na </font></p>
<p class="MsoPlainText" style="margin: 0cm 0cm 0pt;"><font face="Consolas" size="3">> jinem PC, idealne na PC s Windows, poradite?</font></p>
<p class="MsoPlainText" style="margin: 0cm 0cm 0pt;"><font face="Consolas" size="3">> </font></p>
<p class="MsoPlainText" style="margin: 0cm 0cm 0pt;"><font face="Consolas" size="3">> K tomu SQL, CF je flash a tak je zde problem s zivotnosti, puvodne </font></p>
<p class="MsoPlainText" style="margin: 0cm 0cm 0pt;"><font face="Consolas" size="3">> jsem zvazoval PostgreSQL, ale tu asi neumravnim tak, aby tabulky </font></p>
<p class="MsoPlainText" style="margin: 0cm 0cm 0pt;"><font face="Consolas" size="3">> drzela v RAM a treba 1x za den data presypala na CF. Byl mi doporucen </font></p>
<p class="MsoPlainText" style="margin: 0cm 0cm 0pt;"><font face="Consolas" size="3">> Firebird, ale absolutne nic o nem nevim, teda krome toho ze ma pocatky </font></p>
<p class="MsoPlainText" style="margin: 0cm 0cm 0pt;"><font face="Consolas" size="3">> u Borladu.</font></p>
<p class="MsoPlainText" style="margin: 0cm 0cm 0pt;"><font face="Consolas" size="3">> </font></p>
<p class="MsoPlainText" style="margin: 0cm 0cm 0pt;"><font face="Consolas" size="3">> Nepouzivate ji nekdo?</font></p>
<p class="MsoPlainText" style="margin: 0cm 0cm 0pt;"><font face="Consolas" size="3">> Lze tam nadefinova Temp tabulky, ktere se drzi v RAM nebo beh v RAM </font></p>
<p class="MsoPlainText" style="margin: 0cm 0cm 0pt;"><font face="Consolas" size="3">> disku? Nejsou pak problemy s pristupem z .NET aplikaci pres sit? Co </font></p>
<p class="MsoPlainText" style="margin: 0cm 0cm 0pt;"><font face="Consolas" size="3">> appache a php zvladaji spolupraci s FB? Jak slozite je pak v C napsat </font></p>
<p class="MsoPlainText" style="margin: 0cm 0cm 0pt;"><font face="Consolas" size="3">> pod linuxem programek, co bude sosat data z RS-232 a ukladat je do </font></p>
<p class="MsoPlainText" style="margin: 0cm 0cm 0pt;"><font face="Consolas" size="3">> databaze ?</font></p>
<p class="MsoPlainText" style="margin: 0cm 0cm 0pt;"><font face="Consolas" size="3">> </font></p>
<p class="MsoPlainText" style="margin: 0cm 0cm 0pt;"><font face="Consolas" size="3">> Dekuji</font></p>
<p class="MsoPlainText" style="margin: 0cm 0cm 0pt;"><font face="Consolas" size="3">> Pavel</font></p>