Devart Forums

ODAC 5.55
Delphi 7
Oracle 9.2
At extraction of data from field CLOB in mode Net very big traffic. At similar inquiry without mode Net traffic in 10 times is less.How to solve a problem with mode Net?

Ïðè ðàáîòå â ñåòè ñ áàçîé Oracle 9.2 ñëèøêîì áîëüøîé òðàôèê. Êëèåíòñêàÿ ïðîãðàììà âûáèðàåò äàííûå èç ïîëÿ CLOB, â êîòîðîì ëåæèò òåêñò 500-3000 ñèìâîëîâ. Ïðè âûáîðêå ïî îïðåäåë¸ííîìó óñëîâèþ òðàôèê ñîñòàâëÿåò îêîëî 1,5 ìåãàáàéò, õîòÿ ñàì òåêñò â ðåàëüíîñòè çàíèìàåò íå áîëåå 100-120 êèëîáàéò. Åñëè ÿ ïðàâèëüíî ïîíèìàþ òî è òðàôèê äîëæåí áûòü ïðèìåðíî òàêèìæå, íó ÷óòü áîëüøå. Äëÿ ïðîâåðêè çàïóñòèë ñåòåâîé ñíèôåð, ÷òîáû ïîñìîòðåòü ïàêåòû. Ïîëó÷èëîñü ÷òî ñ ñåðâåðà èäóò ïàêåòû ïî 1,5 êèëîáàéòà. Ïîëó÷àåòñÿ ÷òî åñëè â ïàêåòå ëåæèò òåêñò ðàçìåðîì 500 ñèìâîëîâ, òî îñòàëüíîå çàíèìàåò ïóñòîå ìåñòî. Êðîìå òîãî î÷åíü ìíîãî ïóñòûõ ïàêåòîâ, ãäå òîëüêî ñëóæåáíûé çàãîëîâîê (åñëè ýòî òàê íàçûâàåòñÿ), à îñòàëüíîå çàáèòî íóëÿìè. Ïðè îòêëþ÷åíèè Net òðàôôèê ñòàíîâèòñÿ ïðèìåðíî ðàâåí êîëè÷åñòâó äàííûõ, õðàíÿùèõñÿ â ïîëå CLOB, âîáùåì êàê íàäî. Êàê ñäåëàòü ÷òîáû è â ðåæèìå Net òðàôôèê ïðèøåë â íîðìó?

It is known problem. LOB types are slower in Net mode than in OCI connection.
Net option has some restrictions compared to OCI mode.

Paul wrote:It is known problem. LOB types are slower in Net mode than in OCI connection.
Net option has some restrictions compared to OCI mode.

Slow data transmission and traffic - concepts different. Means, that if it is used ODAC it will be necessary ready that instead of 100000 bytes to be passed 1000000 bytes. It does not arrange me. You need to work in this direction. How you consider?

Our results are the following. if you send BLOB of 100000 bytes you would expect 104066 bytes of traffic. if you send BLOB of 100 bytes you would expect 558 bytes of traffic. Yes, these results are not pretty good. We will work on this problem in the future.