1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
37.
38.
39.
40.
41.
42.
43.
44.
45.
46.
47.
48.
49.
50.
51.
52.
53.
54.
55.
56.
57.
58.
59.
60.
61.
62.
63.
64.
65.
66.
67.
68.
69.
70.
71.
72.
73.
74.
75.
76.
77.
78.
79.
80.
81.
82.
83.
84.
85.
86.
87.
88.
89.
90.
91.
92.
93.
94.
95.
96.
97.
98.
99.
100.
101.
102.
103.
104.
105.
106.
107.
108.
109.
110.
111.
112.
113.
114.
115.
116.
117.
118.
119.
120.
121.
122.
123.
124.
125.
126.
127.
128.
129.
130.
131.
132.
133.
134.
135.
136.
137.
138.
139.
140.
141.
142.
143.
144.
145.
146.
147.
148.
149.
150.
151.
152.
153.
154.
155.
156.
157.
158.
159.
<?
function get_microtime()
{
$mtime = microtime();
$mtime = explode( " " ,$mtime);
$mtime = doubleval($mtime[ 1 ] + doubleval($mtime[ 0 ]));
return ($mtime);
}
$old_max_execution_time = ini_set( "max_execution_time" , 17200 );
$marka = array(
"1 " => 1 ,
"2 " => 2 ,
"3 " => 8 ,
"4 " => 45 ,
"5 " => 4 ,
"6 " => 5 ,
"7 " => 6 ,
"8 " => 40 ,
"9 " => 15 ,
"10 " => 2 ,
"11 " => 5 ,
"12 " => 6 ,
"13 " => 3 ,
"14 " => 1 ,
"15 " => 12 ,
"16 " => 16 ,
"17 " => 21 ,
"18 " => 3 ,
"19 " => 18 ,
"20 " => 25 ,
"21 " => 10 ,
"22 " => 2 ,
"23 " => 2 ,
"24 " => 13 ,
"25 " => 1 ,
"26 " => 1 ,
"27 " => 28 ,
"28 " => 30 ,
"29 " => 10 ,
"30 " => 5 ,
"31 " => 24 ,
"32 " => 2 ,
"33 " => 17 ,
"34 " => 2 ,
"35 " => 10 ,
"36 " => 20 ,
"37 " => 1 ,
"38 " => 4 ,
"39 " => 15 ,
"40 " => 9 ,
"41 " => 1 ,
"42 " => 4 ,
"43 " => 6 ,
"44 " => 2 ,
"45 " => 8 ,
"46 " => 3 ,
"47 " => 2 ,
"48 " => 2 ,
"49 " => 1 ,
"50 " => 22 ,
"51 " => 48 ,
"52 " => 4 ,
"53 " => 12 ,
"54 " => 6 ,
"55 " => 18 ,
"56 " => 2 ,
"57 " => 1 ,
"58 " => 15 ,
"59 " => 6 ,
"60 " => 3 ,
"61 " => 38 ,
"62 " => 2 ,
"63 " => 1 ,
"64 " => 2 ,
"65 " => 25 ,
"66 " => 3 ,
"67 " => 5 ,
"68 " => 12 ,
"69 " => 10 ,
"70 " => 3 ,
"71 " => 5 ,
"72 " => 29 ,
"73 " => 7 ,
"74 " => 9 ,
"75 " => 12 ,
"76 " => 20 ,
"77 " => 16 ,
"78 " => 9 ,
"79 " => 1 ,
"80 " => 14 ,
"81 " => 16 ,
"82 " => 2 ,
"83 " => 3 ,
"84 " => 24 ,
"85 " => 8 ,
"86 " => 2 ,
"87 " => 4 ,
"88 " => 4 ,
"89 " => 4 ,
"90 " => 5 ,
"91 " => 40 ,
"92 " => 18 ,
"93 " => 3 ,
"94 " => 1
);
$marka_j = 0 ;
foreach ($marka as $id => $weight)
{
for ($i= 0 ; $i < $weight; $i++)
{
$marka_array[$marka_j++] = $id;
}
}
$time_query2_1 = get_microtime();
$max = 1000 ;
echo "$max<br><br>" ;
for ($i= 0 ; $i<$max; $i++)
{
mt_srand((double)microtime() * 1000000 );
$marka_rand_num = mt_rand( 0 , $marka_j - 1 );
shuffle($marka_array);
$marka_o = $marka_array[$marka_rand_num];
$query_ = " SELECT * FROM tb_model WHERE `id_marka`='$marka_o' " ;
$result_ = mysql_query($query_);
echo mysql_error();
$len=mysql_num_rows($result_)- 1 ;
for ($iii= 0 ; $iii<$len; $iii++)
{
$row_=mysql_fetch_array($result_);
$mass[$iii]=stripslashes($row_[ "id_model" ]);
}
mt_srand((double)microtime() * 1000000 );
$x=mt_rand( 0 , $len);
$model_o=$mass[$x];
$query= "SELECT `id`,`year`,`race`,`price`,`kuzov_id`,`fuel_id`,`korobka_id`,`power`,`color_id`,`par_10`,`handler`,`date_build`
FROM tb_announcement WHERE marka_id='$marka_o' AND `model_id`='$model_o'" ;
$result = mysql_query($query);
}
$time_query2_2 = get_microtime();
$diff_query2 = abs ($time_query2_2 - $time_query2_1);
$diff_query2 = sprintf( "%.6f" , $diff_query2);
echo "<br>$diff_query2 - sec." ;
$S_ps = $max / $diff_query2;
echo "<br>$S_ps - Serch.per.sec." ;
$max_execution_time = ini_get( "max_execution_time" );
?>
