Unable to complete network request to host

Firebird 2.0.3 на FreeBSD
При выполнении запроса (длинного) вылазит ошибка Unable to complete network request to host
на серваке под ВИН- запрос проходит нормально


select r2,r3,r5,r6,nr5,nr6,nr7,nr8,nr9
FROM NR
INNER JOIN R ON (R.R1 = NR.NR1)
WHERE r3<=8 and (r2>="01.09.2010" and r2<="11.12.2010") and r1 in (544 ,550 ,551 ,552 ,40222 ,1773 ,1785 ,1790 ,1791 ,1792 ,1793 ,1795 ,61189 ,61190 ,61191 ,61192 ,2618 ,2622 ,2623 ,105315 ,3108 ,3112 ,3113 ,3114 ,40235 ,3944 ,3945 ,3946 ,40236 ,40237 ,4448 ,4450 ,4454 ,5437 ,5438 ,5439 ,5440 ,5441 ,5452 ,5453 ,5454 ,5455 ,5456 ,5460 ,5461 ,5462 ,5463 ,5467 ,5468 ,5469 ,5470 ,5471 ,5475 ,5476 ,5477 ,5478 ,5676 ,5942 ,5944 ,5945 ,6293 ,6294 ,6849 ,6850 ,6851 ,6852 ,6853 ,7814 ,7821 ,7822 ,7823 ,7824 ,7825 ,7826 ,7834 ,37901 ,37902 ,37908 ,37912 ,10500 ,9932 ,9933 ,9934 ,9935 ,9936 ,10016 ,10017 ,10018 ,41283 ,41284 ,41285 ,41286 ,41287 ,11801 ,11802 ,11803 ,11804 ,11805 ,13945 ,40296 ,40297 ,40298 ,40299 ,40300 ,12408 ,12409 ,40307 ,40308 ,40309 ,40310 ,41288 ,37974 ,37975 ,37976 ,37977 ,37978 ,37979 ,37980 ,37981 ,37982 ,37983 ,37984 ,37985 ,37986 ,40325 ,13267 ,13268 ,13269 ,13270 ,13432 ,13433 ,13434 ,13435 ,13956 ,13957 ,20046 ,20047 ,20048 ,20049 ,20050 ,17605 ,17606 ,17965 ,15752 ,53783 ,37695 ,37699 ,37700 ,16124 ,16125 ,66873 ,37711 ,37712 ,37713 ,37714 ,37715 ,88173 ,88174 ,88175 ,88176 ,88177 ,29932 ,40326 ,40327 ,40328 ,40330 ,40331 ,40332 ,40333 ,41395 ,41399 ,41400 ,41404 ,41405 ,41406 ,41407 ,41408 ,41409 ,41410 ,24995 ,24996 ,24997 ,24998 ,24999 ,25000 ,25001 ,25008 ,25009 ,25010 ,25011 ,25012 ,25013 ,25014 ,25015 ,25016 ,25017 ,25018 ,25019 ,25020 ,27512 ,28554 ,52393 ,52395 ,31173 ,32275 ,32276 ,88178 ,37880 ,37881 ,37882 ,36123 ,103264 ,41491 ,41492 ,41493 ,41494 ,41495 ,99670 ,99671 ,41766 ,41767 ,41768 ,41769 ,41771 ,41772 ,41773 ,41774 ,41775 ,41777 ,41778 ,41779 ,41780 ,42041 ,42042 ,42043 ,42044 ,42049 ,42066 ,42067 ,42068 ,42069 ,88179 ,88180 ,88181 ,88182 ,88183 ,88184 ,46244 ,46245 ,46246 ,46247 ,46248 ,46249 ,100923 ,100925 ,100926 ,100927 ,100928 ,99605 ,99606 ,51159 ,51160 ,51161 ,51162 ,100929 ,91440 ,91441 ,91470 ,91471 ,100931 ,100932 ,100933 ,100934 ,51885 ,66941 ,53139 ,66942 ,66943 ,53440 ,53441 ,53628 ,54989 ,54738 ,54739 ,61172 ,61173 ,65188 ,61339 ,61340 ,100379 ,100380 ,100381 ,59421 ,59429 ,69008 ,69010 ,100493 ,100494 ,27919 ,69011 ,62216 ,62217 ,62218 ,62219 ,62229 ,62230 ,62231 ,62232 ,62233 ,62234 ,62235 ,62236 ,62237 ,62238 ,62239 ,62240 ,62241 ,62242 ,62243 ,105331 ,105332 ,105333 ,63492 ,63493 ,63494 ,63683 ,63684 ,63685 ,90784 ,90785 ,90134 ,90135 ,90136 ,90137 ,90795 ,90796 ,90797 ,90798 ,90799 ,90800 ,90801 ,90803 ,90804 ,90805 ,90806 ,90807 ,90808 ,90809 ,90810 ,66813 ,66851 ,67092 ,67093 ,67446 ,67447 ,67448 ,68222 ,68223 ,68224 ,69050 ,69051 ,69052 ,100697 ,100698 ,100699 ,69881 ,69882 ,69914 ,69915 ,69946 ,69947 ,69948 ,70289 ,70290 ,105334 ,99742 ,99743 ,99744 ,99745 ,99828 ,99829 ,99830 ,99831 ,99833 ,99835 ,10773 ,78981 ,78983 ,78984 ,78985 ,78986 ,78988 ,78989 ,79376 ,79377 ,79378 ,79379 ,79380 ,79654 ,79655 ,79930 ,79931 ,80254 ,80255 ,80256 ,80257 ,80258 ,80259 ,80260 ,80616 ,80617 ,80618 ,80619 ,80620 ,80967 ,80968 ,80969 ,80970 ,80971 ,81495 ,81496 ,81497 ,81498 ,81499 ,81500 ,81501 ,81502 ,81503 ,81504 ,81505 ,81506 ,87993 ,87994 ,87995 ,87996 ,87997 ,87998 ,87999 ,88000 ,82485 ,101437 ,88635 ,91008 ,89828 ,89829 ,89830 ,89831 ,83408 ,83414 ,88025 ,88026 ,88027 ,88031 ,88032 ,88033 ,101643 ,101644 ,101645 ,101646 ,101647 ,101648 ,101649 ,101650 ,101651 ,101652 ,16610 ,16611 ,16612 ,16614 ,16615 ,16616 ,91371 ,91372 ,89071 ,91079 ,91080 ,90101 ,90102 ,89291 ,89292 ,89293 ,89294 ,91536 ,91537 ,91538 ,91539 ,91540 ,91541 ,91542 ,91543 ,91544 ,91822 ,91871 ,91872 ,91873 ,92024 ,92025 ,92026 ,92028 ,92029 ,92031 ,92032 ,92079 ,92080 ,92081 ,92183 ,92184 ,92185 ,92212 ,92213 ,92214 ,92216 ,92217 ,92218 ,103252 ,103254 ,103255 ,103256 ,103257 ,103258 ,103776 ,103968 ,16982 ,16983 ,16984 ,103969 ,102793 ,102794 ,102795 ,102796 ,102797 ,17014 ,102798 ,11596 ,102799 ,17037 ,102800 ,102801 ,102802 ,102803 ,102804 ,102805 ,102806 ,102807 ,102808 ,102809 ,102810 ,102811 ,102823 ,102824 ,102825 ,102826 ,102830 ,102834 ,102835 ,102836 ,98915 ,112869 ,112870 ,112871 ,112872 ,99031 ,112885 ,112889 ,112891 ,99166 ,99221 ,99222 ,112931 ,112932 ,112933 ,112934 ,112935 ,112936 ,112938 ,103777 ,103780 ,103781 ,103783 ,103784 ,103785 ,103786 ,103789 ,103790 ,103793 ,103794 ,103799 ,103800 ,103803 ,103804 ,103259 ,15751 ,15758 ,15759 ,15760 ,15761 ,15787 ,15817 ,15819 ,15820 ,15821 ,15822 ,15881 ,15912 ,15930 ,103261 ,103262 ,103263 ,17607 ,17608 ,17609 ,17610 ,17707 ,17708 ,17709 ,17710 ,17856 ,17857 ,17858 ,17859 ,107114 ,107130 ,107132 ,18348 ,18349 ,18350 ,18351 ,18352 ,18353 ,18354 ,18355 ,18356 ,18358 ,18359 ,18360 ,107186 ,107187 ,107188 ,107189 ,107210 ,107212 ,107257 ,107272 ,107274 ,107320 ,107321 ,107322 ,107323 ,105387 ,105388 ,18826 ,18827 ,18828 ,107366 ,18829 ,18830 ,18831 ,18832 ,18833 ,18834 ,18835 ,18836 ,18837 ,18838 ,18839 ,18840 ,18849 ,18850 ,18851 ,105389 ,105390 ,105411 ,105412 ,105413 ,105414 ,105432 ,105911 ,105445 ,105458 ,105473 ,105474 ,105475 ,105476 ,105925 ,105933 ,109078 ,105938 ,105521 ,105522 ,105523 ,105524 ,23424 ,23425 ,23426 ,23427 ,23428 ,23429 ,23430 ,23431 ,23432 ,23433 ,23434 ,23435 ,23436 ,23437 ,23438 ,23439 ,23440 ,23441 ,23442 ,23443 ,23444 ,23445 ,23446 ,23447 ,23448 ,109088 ,105555 ,105567 ,25336 ,25337 ,25338 ,25339 ,25340 ,25341 ,25354 ,25355 ,25356 ,25357 ,25358 ,25359 ,25360 ,25368 ,25369 ,25370 ,25371 ,25372 ,25373 ,25374 ,105951 ,109094 ,105973 ,30292 ,30352 ,105987 ,105998 ,30736 ,30737 ,30748 ,30749 ,30750 ,30751 ,30764 ,30765 ,30767 ,30768 ,30769 ,30770 ,30772 ,30773 ,30774 ,30775 ,31611 ,31612 ,31613 ,31614 ,31615 ,31616 ,31617 ,31618 ,106011 ,109110 ,109121 ,116948 ,116949 ,118086 ,118087 ,113637 ,113653 ,113654 ,113655 ,113656 ,113713 ,113714 ,113715 ,113716 ,113741 ,113742 ,113743 ,113744 ,113762 ,113775 ,113787 ,113799 ,113800 ,113801 ,113802 ,113843 ,113844 ,113845 ,113846 ,112741 ,112742 ,112743 ,112744 ,112751 ,113884 ,113895 ,113987 ,113988 ,113990 ,113991 ,113992 ,113993 ,113994 ,113995 ,113996 ,113997 ,117301 ,117302 ,114452 ,114453 ,114454 ,114471 ,114495 ,114496 ,114497 ,114520 ,114683 ,114685 ,117928 ,114903 ,114904 ,117985 ,117986 ,117987 ,117988 ,118088 ,118089 ,118090 ,118091 ,114951 ,114952 ,114953 ,114969 ,114997 ,114998 ,114999 ,115027 ,115151 ,115152 ,115389 ,115390 ,115391 ,115407 ,115435 ,115436 ,115437 ,118672 ,115465 ,115486 ,115487 ,115488 ,115505 ,115523 ,115524 ,115525 ,115548 ,115578 ,115579 ,115580 ,115581 ,115590 ,115605 ,115606 ,115607 ,115608 ,115633 ,118805 ,116345 ,116346 ,116347 ,116348 ,116349 ,116350 ,116351 ,116352 ,116571 ,116613 ,119712 ,119713 ,120191 ,120192 ,120193 ,120197 ,120198 ,120199 ,120200 ,120201 ,120202 ,120229 ,120230 ,120231 ,120236 ,120237 ,120238 ,120239 ,120240 ,120243 ,120244 ,120246 ,120750 ,121470 ,121471 ,121472 ,121473 ,121474 ,121475 ,121476 ,121477 ,121478 ,121479 ,121480 ,121481 ,121482 ,121483 ,121484 ,121485 ,121560 ,121561 ,121562 ,121563 ,121623 ,121624 ,121625 ,121626 ,121627 ,121628 ,121629 ,121630 ,121631 ,121632 ,121633 ,121634 ,121635 ,121636 ,121637 ,121638 ,121639 ,121640 ,121641 ,121642 ,121643) order by r2,r3

если убрать 40 условий- запрос выполняется!

Можно ли это исправить?

1. Убрать пробелы внутри in() перед запятыми - хоть какая экономия
2. Переделать в человеческий вид: IDшники сбрасывать в GTT, рузультат получать через join основной таблицы и GTT.

0

arni, Может ошибаюсь, но мне казалось, сто GTT появилось, начиная с 2.1

0

Верно подмечено, GTT в 2.0.х еще отсутствовали

Топикстартеру еще на заметку: покурить насчет вычленения из длинного списка ID диапазонов (цепочек). Например
...18829 ,18830 ,18831 ,18832 ,18833 ,18834 ,18835 ,18836 ,18837 ,18838 ,18839 ,18840...
=>
... or r1 between 18829 and 18840 or ...

0