You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Включил мониторинг обращения к базе. (FlylinkDC.exe /sqltrace)
В логе sqltrace.log обнаружилось, что для всех файлов найденных поиском выполняется последовательность команд вида:
хотя они нужны только в момент отрисовки.
При не точных запросах вида dvdrip или mkv это создает лишнюю нагрузку на базу данных.
[2013-06-10 23:42:31] select (select name from fly_dic where id = dic_location),
flag_index from fly_location_ip where start_ip <= 1423565421 and stop_ip > 1423565421
[2013-06-10 23:42:31] select (select name from fly_dic where id=country), flag_index from fly_country_ip where start_ip <= 1423565421 order by start_ip desc limit 1
[2013-06-10 23:42:31] select 1 from fly_tth where tth=x'fcf0b3cb9daf0100bdf6888ce57d5b6f78f6c1338ea1289b'
union all
select 2 from fly_hash where tth=x'fcf0b3cb9daf0100bdf6888ce57d5b6f78f6c1338ea1289b'
[2013-06-10 23:42:31] select 1 from fly_tth where tth=x'8cf94daaf8acfc8f79d0f374c27740681cbe30c47ec92fcb'
union all
select 2 from fly_hash where tth=x'8cf94daaf8acfc8f79d0f374c27740681cbe30c47ec92fcb'
[2013-06-10 23:42:31] select (select name from fly_dic where id = dic_location),
flag_index from fly_location_ip where start_ip <= 1423565421 and stop_ip > 1423565421
[2013-06-10 23:42:31] select (select name from fly_dic where id=country), flag_index from fly_country_ip where start_ip <= 1423565421 order by start_ip desc limit 1
[2013-06-10 23:42:31] select 1 from fly_tth where tth=x'8cf94daaf8acfc8f79d0f374c27740681cbe30c47ec92fcb'
union all
select 2 from fly_hash where tth=x'8cf94daaf8acfc8f79d0f374c27740681cbe30c47ec92fcb'
[2013-06-10 23:42:31] select 1 from fly_tth where tth=x'528a224c4726d8b46e2e674ae05a62fb7469a8586476d01f'
union all
select 2 from fly_hash where tth=x'528a224c4726d8b46e2e674ae05a62fb7469a8586476d01f'
[2013-06-10 23:42:31] select (select name from fly_dic where id = dic_location),
flag_index from fly_location_ip where start_ip <= 3162919515 and stop_ip > 3162919515
[2013-06-10 23:42:31] select 1 from fly_tth where tth=x'528a224c4726d8b46e2e674ae05a62fb7469a8586476d01f'
From Pavel.Pimenov@gmail.com on June 10, 2013 21:48:25
хотя они нужны только в момент отрисовки.
При не точных запросах вида dvdrip или mkv это создает лишнюю нагрузку на базу данных.
[2013-06-10 23:42:31] select (select name from fly_dic where id = dic_location),
flag_index from fly_location_ip where start_ip <= 1423565421 and stop_ip > 1423565421
[2013-06-10 23:42:31] select (select name from fly_dic where id=country), flag_index from fly_country_ip where start_ip <= 1423565421 order by start_ip desc limit 1
[2013-06-10 23:42:31] select 1 from fly_tth where tth=x'fcf0b3cb9daf0100bdf6888ce57d5b6f78f6c1338ea1289b'
union all
select 2 from fly_hash where tth=x'fcf0b3cb9daf0100bdf6888ce57d5b6f78f6c1338ea1289b'
[2013-06-10 23:42:31] select 1 from fly_tth where tth=x'8cf94daaf8acfc8f79d0f374c27740681cbe30c47ec92fcb'
union all
select 2 from fly_hash where tth=x'8cf94daaf8acfc8f79d0f374c27740681cbe30c47ec92fcb'
[2013-06-10 23:42:31] select (select name from fly_dic where id = dic_location),
flag_index from fly_location_ip where start_ip <= 1423565421 and stop_ip > 1423565421
[2013-06-10 23:42:31] select (select name from fly_dic where id=country), flag_index from fly_country_ip where start_ip <= 1423565421 order by start_ip desc limit 1
[2013-06-10 23:42:31] select 1 from fly_tth where tth=x'8cf94daaf8acfc8f79d0f374c27740681cbe30c47ec92fcb'
union all
select 2 from fly_hash where tth=x'8cf94daaf8acfc8f79d0f374c27740681cbe30c47ec92fcb'
[2013-06-10 23:42:31] select 1 from fly_tth where tth=x'528a224c4726d8b46e2e674ae05a62fb7469a8586476d01f'
union all
select 2 from fly_hash where tth=x'528a224c4726d8b46e2e674ae05a62fb7469a8586476d01f'
[2013-06-10 23:42:31] select (select name from fly_dic where id = dic_location),
flag_index from fly_location_ip where start_ip <= 3162919515 and stop_ip > 3162919515
[2013-06-10 23:42:31] select 1 from fly_tth where tth=x'528a224c4726d8b46e2e674ae05a62fb7469a8586476d01f'
Original issue: http://code.google.com/p/flylinkdc/issues/detail?id=1060
The text was updated successfully, but these errors were encountered: