Вручную запустил 10 экземпляров приложения-тестировщика. Локов не было. Функции написаны на дефолтном языке. Функция купли или продажи содержит всего 250 строк включая пробелы и комментарии и другие артефакты для отладки
|
|
|
Энтерпрайз).... может кто-то я хочет Postgre форкнуть))) предыдущий за него топил)))
|
|
|
А что именно делают эти селекты? Там же еще и апдейты и инсерты должны быть...
это функция, которая реализует алгоритм биржевой торговли. остается только вывести таблицы) балансы меняются автоматически, тк тоже в таблицах все внутри БД
|
|
|
20 тыс ордеров проведено. после этого в стаканах осталось по 2 тыс не исполненных ордеров. публикую последние строки теста select buybtcR(705.22,0.00740590,3);11121 mcs select sellbtcR(630.92,0.00802493,3); 26765 mcs select buybtcR(185.07,0.00962241,3);29069 mcs select sellbtcR(435.84,0.00473537,2); 10746 mcs select buybtcR(408.71,0.00244875,3);155708 mcs select sellbtcR(658.31,0.00410866,2); 11257 mcs select buybtcR(576.58,0.00998753,1);11023 mcs select sellbtcR(583.55,0.00196305,2); 11201 mcs select buybtcR(700.78,0.00913356,2);22160 mcs select sellbtcR(42.29,0.00914930,2); 22007 mcs select buybtcR(782.88,0.00190901,1);11078 mcs select sellbtcR(585.37,0.00329407,1); 11190 mcs select buybtcR(547.61,0.00391641,1);11045 mcs select sellbtcR(21.15,0.00649772,2); 11123 mcs select buybtcR(266.02,0.00375255,1);11229 mcs select sellbtcR(676.89,0.00164506,1); 11248 mcs select buybtcR(675.64,0.00207455,3);11109 mcs select sellbtcR(871.95,0.00921576,3); 11065 mcs select buybtcR(785.30,0.00054354,2);177927 mcs select sellbtcR(700.23,0.00991648,2); 11193 mcs select buybtcR(891.13,0.00927551,3);22193 mcs select sellbtcR(220.54,0.00568675,1); 22072 mcs select buybtcR(612.18,0.00840720,1);11016 mcs select sellbtcR(261.95,0.00297831,2); 11230 mcs select buybtcR(637.21,0.00190780,1);11089 mcs select sellbtcR(801.72,0.00492443,2); 11151 mcs вот последний ордер из 20 тыс исполнился за 0.11 сек в следующий раз запущу 100 копий приложения для тестирования, посмотреть не будет ли ерорлоков БД
|
|
|
Конечно нормально. Если с такой скоростью будет работать реальная биржа, то это будет очень круто!
Не будет. Это 200 ордеров на пустом стакане. Вечером будет время, 10 тыс прогоню и посчитаю
|
|
|
Получается 50 $ за переходник? Или снимается стандартная система охлаждения GPU? Фото правда не хватает.
|
|
|
Привет, kzv. Год назад в новогодние праздники был разговор о sqlite и о ядрах бирж. Я тут накидал биржу прямо внутри PostgreSQL .. 2 функции всего купить битки за рубли и продать. 200 ордеров выполняются чуть больше чем за 2 секунды. Нормально? 1578325171347409 SystemSeconds:1578325171.347409 select buybtcR(783.10,0.00394383,2);select sellbtcR(197.55,0.00911647,2); select buybtcR(277.77,0.00768230,2);select sellbtcR(628.87,0.00477397,2); select buybtcR(952.23,0.00513401,3);select sellbtcR(717.30,0.00635712,2); select buybtcR(16.30,0.00606969,2);select sellbtcR(804.18,0.00137232,3); select buybtcR(129.79,0.00400944,3);select sellbtcR(218.26,0.00998924,2); select buybtcR(612.64,0.00839112,3);select sellbtcR(524.29,0.00637552,1); select buybtcR(292.52,0.00972775,2);select sellbtcR(769.91,0.00526745,2); select buybtcR(283.31,0.00891529,1);select sellbtcR(919.03,0.00807725,2); select buybtcR(526.00,0.00949327,3);select sellbtcR(663.23,0.00192214,2); select buybtcR(64.17,0.00348893,3);select sellbtcR(63.10,0.00457702,3); select buybtcR(902.21,0.00970634,1);select sellbtcR(539.76,0.00266666,1); select buybtcR(512.54,0.00760249,2);select sellbtcR(39.28,0.00531606,3); select buybtcR(930.81,0.00931835,1);select sellbtcR(738.53,0.00284293,1); select buybtcR(687.86,0.00354049,1);select sellbtcR(880.08,0.00440104,1); select buybtcR(228.97,0.00330337,3);select sellbtcR(686.67,0.00350360,3); select buybtcR(657.30,0.00588640,1);select sellbtcR(923.97,0.00439560,1); select buybtcR(684.22,0.00814767,2);select sellbtcR(215.82,0.00482491,3); select buybtcR(147.66,0.00920128,3);select sellbtcR(431.95,0.00641081,1); select buybtcR(786.00,0.00281059,1);select sellbtcR(226.11,0.00447034,3); select buybtcR(556.44,0.00276235,3);select sellbtcR(906.80,0.00169607,3); select buybtcR(495.44,0.00126075,2);select sellbtcR(935.00,0.00984752,2); select buybtcR(749.77,0.00383188,1);select sellbtcR(232.26,0.00294160,2); select buybtcR(152.39,0.00244413,3);select sellbtcR(793.47,0.00125475,3); select buybtcR(74.53,0.00745071,3);select sellbtcR(521.56,0.00052529,1); select buybtcR(797.80,0.00240062,1);select sellbtcR(967.41,0.00656564,1); select buybtcR(93.48,0.00759735,2);select sellbtcR(78.23,0.00520210,3); select buybtcR(461.42,0.00204655,3);select sellbtcR(755.58,0.00573319,3); select buybtcR(999.99,0.00157807,3);select sellbtcR(125.47,0.00889956,3); select buybtcR(870.54,0.00054058,3);select sellbtcR(923.07,0.00004162,2); select buybtcR(163.13,0.00180372,1);select sellbtcR(819.70,0.00913027,2); select buybtcR(579.43,0.00552485,2);select sellbtcR(99.64,0.00687387,2); select buybtcR(304.30,0.00757294,1);select sellbtcR(877.61,0.00576971,2); select buybtcR(35.42,0.00628910,1);select sellbtcR(925.38,0.00833239,3); select buybtcR(979.43,0.00831037,1);select sellbtcR(983.60,0.00903366,2); select buybtcR(163.97,0.00497259,3);select sellbtcR(76.99,0.00888949,2); select buybtcR(629.48,0.00248044,1);select sellbtcR(316.87,0.00700620,1); select buybtcR(74.16,0.00231428,3);select sellbtcR(651.13,0.00223656,3); select buybtcR(280.04,0.00971466,2);select sellbtcR(113.28,0.00719269,1); select buybtcR(944.32,0.00592540,3);select sellbtcR(847.68,0.00336351,3); select buybtcR(344.94,0.00003231,2);select sellbtcR(233.89,0.00833243,2); select buybtcR(481.94,0.00482950,3);select sellbtcR(182.56,0.00712087,1); select buybtcR(413.98,0.00040864,2);select sellbtcR(637.64,0.00673936,2); select buybtcR(609.11,0.00184622,2);select sellbtcR(328.37,0.00730729,3); select buybtcR(920.91,0.00202213,2);select sellbtcR(257.27,0.00653130,3); select buybtcR(260.50,0.00087644,1);select sellbtcR(93.74,0.00686125,1); select buybtcR(576.69,0.00361601,1);select sellbtcR(288.78,0.00666557,3); select buybtcR(329.64,0.00288379,3);select sellbtcR(3.58,0.00984363,3); select buybtcR(188.20,0.00331479,2);select sellbtcR(918.93,0.00958637,1); select buybtcR(121.14,0.00699075,3);select sellbtcR(774.27,0.00383832,1); select buybtcR(861.92,0.00916273,3);select sellbtcR(548.04,0.00793657,3); select buybtcR(909.64,0.00904933,2);select sellbtcR(576.20,0.00498144,1); select buybtcR(864.58,0.00273911,1);select sellbtcR(848.94,0.00463662,1); select buybtcR(180.42,0.00291053,2);select sellbtcR(139.06,0.00727550,1); select buybtcR(838.13,0.00492422,1);select sellbtcR(221.97,0.00178208,1); select buybtcR(138.24,0.00121259,2);select sellbtcR(931.90,0.00324807,2); select buybtcR(836.83,0.00622095,2);select sellbtcR(334.97,0.00496074,3); select buybtcR(608.88,0.00658831,3);select sellbtcR(72.55,0.00151230,2); select buybtcR(363.60,0.00647207,2);select sellbtcR(91.15,0.00331386,2); select buybtcR(583.57,0.00934495,2);select sellbtcR(761.78,0.00658747,3); select buybtcR(883.04,0.00157272,3);select sellbtcR(207.84,0.00517715,3); select buybtcR(829.94,0.00426199,3);select sellbtcR(326.01,0.00244327,3); select buybtcR(984.84,0.00638654,1);select sellbtcR(136.07,0.00897560,2); select buybtcR(783.28,0.00005409,3);select sellbtcR(114.67,0.00293678,3); select buybtcR(49.16,0.00721006,2);select sellbtcR(707.91,0.00986467,2); select buybtcR(865.18,0.00473894,3);select sellbtcR(382.90,0.00099559,2); select buybtcR(809.10,0.00657120,1);select sellbtcR(53.42,0.00051508,2); select buybtcR(692.08,0.00780868,3);select sellbtcR(589.64,0.00119111,1); select buybtcR(595.05,0.00529899,2);select sellbtcR(888.72,0.00304285,1); select buybtcR(609.73,0.00169820,2);select sellbtcR(596.20,0.00618925,2); select buybtcR(70.09,0.00829808,1);select sellbtcR(169.65,0.00923728,1); select buybtcR(826.77,0.00225491,3);select sellbtcR(878.28,0.00357193,3); select buybtcR(659.15,0.00814909,2);select sellbtcR(778.26,0.00257469,3); select buybtcR(308.16,0.00836104,1);select sellbtcR(612.44,0.00198021,2); select buybtcR(782.26,0.00674605,1);select sellbtcR(401.19,0.00200352,1); select buybtcR(231.00,0.00434009,1);select sellbtcR(154.72,0.00532846,2); select buybtcR(380.21,0.00014579,2);select sellbtcR(737.41,0.00305408,1); select buybtcR(552.32,0.00649659,3);select sellbtcR(809.79,0.00685986,1); select buybtcR(645.89,0.00311950,3);select sellbtcR(843.91,0.00532960,3); select buybtcR(518.51,0.00642692,2);select sellbtcR(718.87,0.00362154,1); select buybtcR(152.88,0.00677812,2);select sellbtcR(685.72,0.00063561,2); select buybtcR(700.30,0.00618958,1);select sellbtcR(5.71,0.00001125,3); select buybtcR(655.37,0.00261570,3);select sellbtcR(341.35,0.00181161,3); select buybtcR(653.30,0.00879009,1);select sellbtcR(186.26,0.00885014,3); select buybtcR(828.96,0.00503461,3);select sellbtcR(191.11,0.00904170,1); select buybtcR(868.92,0.00706067,1);select sellbtcR(932.48,0.00738959,1); select buybtcR(551.44,0.00926576,3);select sellbtcR(552.57,0.00494407,1); select buybtcR(814.14,0.00799646,2);select sellbtcR(995.30,0.00657201,3); select buybtcR(874.31,0.00324541,3);select sellbtcR(759.32,0.00637771,1); select buybtcR(262.78,0.00794910,2);select sellbtcR(166.95,0.00470564,2); select buybtcR(873.02,0.00865085,3);select sellbtcR(611.98,0.00412483,1); select buybtcR(538.56,0.00645602,2);select sellbtcR(32.96,0.00579021,2); select buybtcR(832.61,0.00518151,3);select sellbtcR(489.81,0.00112648,1); select buybtcR(814.35,0.00048500,1);select sellbtcR(452.12,0.00637656,3); select buybtcR(247.03,0.00413078,1);select sellbtcR(717.60,0.00017457,2); select buybtcR(582.68,0.00812947,3);select sellbtcR(995.16,0.00477361,2); select buybtcR(640.77,0.00074260,1);select sellbtcR(219.79,0.00222602,1); select buybtcR(737.94,0.00923513,2);select sellbtcR(850.59,0.00438562,3); select buybtcR(899.09,0.00948911,2);select sellbtcR(536.74,0.00333569,2); select buybtcR(949.82,0.00477551,1);select sellbtcR(967.28,0.00884318,2); select buybtcR(780.22,0.00458039,1);select sellbtcR(257.59,0.00904781,2); 1578325173597722 SystemSeconds:1578325173.597722
|
|
|
F fiat )))) 1Gb66ozUCxyZEDk2MJsizvg7bPSHveDL96
|
|
|
Собираемся 1 ноября. Это окончательный срок Медведева
|
|
|
Простите за сленг топика. Но это тренд роскомнадзора. В жизни мат стараюсь не употреб...ть.
Почитал я идеи и не нашел новой. Все что есть ценного так это только идея Накамото.
Предлагаю голосовать за закрытие этой ветки.
Просто стоящими идеями вот так не делятся в открытую. А ветка полезная, даже плохие идеи могут натолкнуть на правильный вектор мышления и привести к действительно стоящим идеям Стоящими идеями делятся в открытую. Именно так растет ее вес. Критика твоей идеи развивает ее. Но самое интересное, что многие собеседники говорят тебе, что имеют схожие идеи и только так можно найти единомышленников.
|
|
|
Гораздо приятнее мечтать о ковре-самолете и скатерти-самобранке)
|
|
|
Завтра на квантовом компе ключ подберут и будет вам Сатоши... и подписи Шнура
|
|
|
Весь интернет уже флудильня. Нет толковых идей. Иногда здесь можно встретить хороших людей. Но все реже и реже.
|
|
|
Изначально ветка была про идеи: "где можно применить биткоин". Потом это стало веткой: "я тут придумал кое-что, кто даст денег - тому расскажу" Сейчас я смотрю новый тренд: "где можно применить блокчейн".
Ветка эволюционирует вместе с биткоином )
Деградация тоже эволюция (; Читайте вайтпепер Герберта Уэллса Для чего? Видео не так реалистично.
|
|
|
Я думал все будет хорошо. А там опять все вексанулось
|
|
|
Изначально ветка была про идеи: "где можно применить биткоин". Потом это стало веткой: "я тут придумал кое-что, кто даст денег - тому расскажу" Сейчас я смотрю новый тренд: "где можно применить блокчейн".
Ветка эволюционирует вместе с биткоином )
Деградация тоже эволюция (; Читайте вайтпепер Герберта Уэллса
|
|
|
|