dolphindb cacheSize

cacheSize 表示流数据表在内存中最多保留多少行。如果它为0或者没有指定,所有记录行都会保存在内存中。默认值为-1。如果 cacheSize 是小于100,000的正整数,它会被自动调整为100,000.

设置:
enableTableShareAndPersistence(table=h_mt,tableName=`h_m,preCache=10,cacheSize=60,retentionMinutes=60)
select  count(*)  from h_m
查询结果500 到1000 变化,最大不超过1000行
不是最大100,000.,也不是我设置的60,与描述的不想符合, 为什么?




h_mt = streamTable(2000:0,`sj`b`data1`data2`data3`data4`data5`data6`data7`data8`data9`data10`data11`data12`data13`data14`data15`data16`data17`data18`data19`data20`data21`data22`data23`data24`data25`data26`data27`data28`data29`data30`data31`data32`data33`data34`data35`data36`data37`data38`data39`data40`data41`data42`data43`data44`data45`data46`data47`data48`data49`data50`data51`data52`data53`data54`data55`data56`data57`data58`data59`data60`data61`data62`data63`data64`data65`data66`data67`data68`data69`data70`data71`data72`data73`data74`data75`data76`data77`data78`data79`data80`data81`data82`data83`data84`data85`data86`data87`data88`data89`data90`data91`data92`data93`data94`data95`data96`data97`data98`data99`data100`data101`data102`data103`data104`data105`data106`data107`data108`data109`data110`data111`data112`data113`data114`data115`data116`data117`data118`data119`data120`data121`data122`data123`data124`data125`data126`data127`data128`data129`data130`data131`data132`data133`data134`data135`data136`data137`data138`data139`data140`data141`data142`data143`data144`data145`data146`data147`data148`data149`data150`data151`data152`data153`data154`data155`data156`data157`data158`data159`data160`data161`data162`data163`data164`data165`data166`data167`data168`data169`data170`data171`data172`data173`data174`data175`data176`data177`data178`data179`data180`data181`data182`data183`data184`data185`data186`data187`data188`data189`data190`data191`data192`data193`data194`data195`data196`data197`data198`data199`data200`data201`data202`data203`data204`data205`data206`data207`data208`data209`data210`data211`data212`data213`data214`data215`data216`data217`data218`data219`data220`data221`data222`data223`data224`data225`data226`data227`data228`data229`data230`data231`data232`data233`data234`data235`data236`data237`data238`data239`data240`data241`data242`data243`data244`data245`data246`data247`data248`data249`data250`data251`data252`data253`data254`data255`data256`data257`data258`data259`data260`data261`data262`data263`data264`data265`data266`data267`data268`data269`data270`data271`data272`data273`data274`data275`data276`data277`data278`data279`data280`data281`data282`data283`data284`data285`data286`data287`data288`data289`data290`data291`data292`data293`data294`data295`data296`data297`data298`data299`data300`data301`data302`data303`data304`data305`data306`data307`data308`data309`data310`data311`data312`data313`data314`data315`data316`data317`data318`data319`data320`data321`data322`data323`data324`data325`data326`data327`data328`data329`data330`data331`data332`data333`data334`data335`data336`data337`data338`data339`data340`data341`data342`data343`data344`data345`data346`data347`data348`data349`data350`data351`data352`data353`data354`data355`data356`data357`data358`data359`data360`data361`data362`data363`data364`data365`data366`data367`data368`data369`data370`data371`data372`data373`data374`data375`data376`data377`data378`data379`data380`data381`data382`data383`data384`data385`data386`data387`data388`data389`data390`data391`data392`data393`data394`data395`data396`data397`data398`data399`data400`data401`data402`data403`data404`data405`data406`data407`data408`data409`data410`data411`data412`data413`data414`data415`data416`data417`data418`data419`data420`data421`data422`data423`data424`data425`data426`data427`data428`data429`data430`data431`data432`data433`data434`data435`data436`data437`data438`data439`data440`data441`data442`data443`data444`data445`data446`data447`data448`data449`data450`data451`data452`data453`data454`data455`data456`data457`data458`data459`data460`data461`data462`data463`data464`data465`data466`data467`data468`data469`data470`data471`data472`data473`data474`data475`data476`data477`data478`data479`data480`data481`data482`data483`data484`data485`data486`data487`data488`data489`data490`data491`data492`data493`data494`data495`data496`data497`data498`data499`data500`data501`data502`data503`data504`data505`data506`data507`data508`data509`data510`data511`data512`data513`data514`data515`data516`data517`data518`data519`data520`data521`data522`data523`data524`data525`data526`data527`data528`data529`data530`data531`data532`data533`data534`data535`data536`data537`data538`data539`data540`data541`data542`data543`data544`data545`data546`data547`data548`data549`data550`data551`data552`data553`data554`data555`data556`data557`data558`data559`data560`data561`data562`data563`data564`data565`data566`data567`data568`data569`data570`data571`data572`data573`data574`data575`data576`data577`data578`data579`data580`data581`data582`data583`data584`data585`data586`data587`data588`data589`data590`data591`data592`data593`data594`data595`data596`data597`data598`data599`data600`data601`data602`data603`data604`data605`data606`data607`data608`data609`data610`data611`data612`data613`data614`data615`data616`data617`data618`data619`data620`data621`data622`data623`data624`data625`data626`data627`data628`data629`data630`data631`data632`data633`data634`data635`data636`data637`data638`data639`data640`data641`data642`data643`data644`data645`data646`data647`data648`data649`data650`data651`data652`data653`data654`data655`data656`data657`data658`data659`data660`data661`data662`data663`data664`data665`data666`data667`data668`data669`data670`data671`data672`data673`data674`data675`data676`data677`data678`data679`data680`data681`data682`data683`data684`data685`data686`data687`data688`data689`data690`data691`data692`data693`data694`data695`data696`data697`data698`data699`data700`data701`data702`data703`data704`data705`data706`data707`data708`data709`data710`data711`data712`data713`data714`data715`data716`data717`data718`data719`data720,[TIMESTAMP,symbol,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float,float])

enableTableShareAndPersistence(table=h_mt,tableName=`h_m,preCache=10,cacheSize=60,retentionMinutes=60)


请先 登录 后评论
  • 0 关注
  • 0 收藏,461 浏览
  • zhchtao323 提出于 2023-09-05 08:06

相似问题