Cursor gets slower and slower
-
zipfindzips2
==================
10001,00501,50
10001,06460,58
10001,06468,56
10001,06470,57
10001,06484,59
10001,06497,55
10001,06601,51
10001,06606,51
10001,06611,53
10001,06612,50
10001,06615,54
10001,06807,29
10001,06810,52
10001,06811,54
10001,06820,35
10001,06824,48
10001,06825,50
10001,06829,47
10001,06830,27
10001,06831,28
10001,06840,38
10001,06850,39
10001,06851,40
10001,06854,38
10001,06855,39
10001,06877,46
10001,06878,29
10001,06880,43
10001,06881,43
10001,06883,46
10001,06897,42
10001,06901,32
10001,06907,34
10001,07002,8
10001,07003,10
10001,07004,18
10001,07006,16
10001,07009,14
10001,07010,5
10001,07011,11
10001,07012,11
10001,07013,12
10001,07015,12
10001,07016,17
10001,07017,11
10001,07020,5
10001,07022,4
10001,07024,7
10001,07026,10
10001,07027,19
10001,07029,9
10001,07030,2
10001,07031,7
10001,07032,8
10001,07039,17
10001,07040,14
10001,07041,16
10001,07042,12
10001,07045,22
10001,07047,3
10001,07050,12
10001,07052,14
10001,07054,23
10001,07055,10
10001,07057,9
10001,07058,20
10001,07059,28
10001,07060,24
10001,07063,25
10001,07066,19
10001,07067,19
10001,07068,17
10001,07070,8
10001,07072,8
10001,07073,8
10001,07074,7
10001,07075,8
10001,07076,21
10001,07078,18
10001,07079,14
10001,07080,25
10001,07081,17
10001,07083,14
10001,07087,2
10001,07093,2
10001,07095,20
10001,07097,4
10001,07101,9
10001,07102,9
10001,07108,10
10001,07109,9
10001,07110,9
10001,07111,13
10001,07112,11
10001,07201,12
10001,07203,15
10001,07204,15
10001,07205,12
10001,07302,3
10001,07305,5
10001,07306,3
10001,07403,25
10001,07405,25
10001,07407,12
10001,07410,14
10001,07417,21
10001,07421,35
10001,07424,15
10001,07430,24
10001,07432,19
10001,07436,23
10001,07442,23
10001,07446,22
10001,07450,17
10001,07456,28
10001,07463,20
10001,07470,18
10001,07474,19
10001,07480,31
10001,07501,15
10001,07506,16
10001,07508,16
10001,07511,16
10001,07601,10
10001,07603,8
10001,07604,8
10001,07621,12
10001,07624,15
10001,07626,13
10001,07631,10
10001,07641,14
10001,07642,18
10001,07650,7
10001,07652,14
10001,07657,6
10001,07661,12
10001,07662,11
10001,07666,9
10001,07675,17
10001,07676,17
10001,07701,27
10001,07712,35
10001,07715,41
10001,07716,24
10001,07719,39
10001,07721,25
10001,07724,31
10001,07726,35
10001,07727,39
10001,07728,38
10001,07730,24
10001,07731,43
10001,07733,27
10001,07734,22
10001,07735,24
10001,07739,28
10001,07746,30
10001,07747,26
10001,07748,24
10001,07751,31
10001,07756,37
10001,07757,30
10001,07758,22
10001,07762,41
10001,07763,39
10001,07801,31
10001,07821,41
10001,07822,46
10001,07823,55
10001,07826,49
10001,07827,55
10001,07828,40
10001,07831,50
10001,07832,57
10001,07834,27
10001,07840,44
10001,07847,34
10001,07852,36
10001,07853,41
10001,07856,36
10001,07860,47
10001,07866,30
10001,07869,31
10001,07871,39
10001,07876,35
10001,07882,52
10001,07901,19
10001,07920,30
10001,07921,35
10001,07930,36
10001,07932,21
10001,07936,19
10001,07940,22
10001,07945,31
10001,07960,25
10001,07980,27
10001,07981,23
10001,08501,50
10001,08502,40
10001,08505,56
10001,08512,41
10001,08520,43
10001,08527,46
10001,08528,42
10001,08530,55
10001,08536,42
10001,08540,43
10001,08544,44
10001,08557,48
10001,08560,54
10001,08601,48
10001,08609,54
10001,08618,54
10001,08620,53
10001,08628,54
10001,08648,50
10001,08690,51
10001,08701,48
10001,08723,49
10001,08724,46
10001,08733,53
10001,08735,53
10001,08742,46
10001,08753,54
10001,08759,56
10001,08802,53
10001,08805,31
10001,08807,34
10001,08809,48
10001,08812,27
10001,08816,30
10001,08817,26
10001,08818,26
10001,08820,22
10001,08822,47
10001,08824,37
10001,08825,57
10001,08826,48
10001,08829,48
10001,08830,20
10001,08831,36
10001,08833,44
10001,08835,34
10001,08837,23
10001,08840,23
10001,08844,38
10001,08846,29
10001,08848,59
10001,08853,42
10001,08854,28
10001,08857,29
10001,08859,25
10001,08861,21
10001,08863,22
10001,08871,27
10001,08872,27
10001,08873,31
10001,08876,36
10001,08885,45
10001,08901,30
10001,08902,32
10001,10001,0
10001,10002,2
10001,10003,1
10001,10004,3
10001,10005,3
10001,10006,3
10001,10007,2
10001,10008,3
10001,10009,1
10001,10010,0
10001,10011,0
10001,10012,1
10001,10013,2
10001,10014,1
10001,10015,2
10001,10016,0
10001,10017,0
10001,10018,0
10001,10019,1
10001,10021,2
10001,10022,1
10001,10023,2
10001,10024,2
10001,10025,3
10001,10026,4
10001,10028,2
10001,10029,4
10001,10031,5
10001,10032,7
10001,10033,7
10001,10034,8
10001,10036,0
10001,10038,3
10001,10039,6
10001,10101,1
10001,10128,3
10001,10278,2
10001,10282,3
10001,10301,10
10001,10302,11
10001,10304,10
10001,10305,11
10001,10306,14
10001,10308,15
10001,10309,18
10001,10312,17
10001,10314,12
10001,10451,6
10001,10452,7
10001,10453,8
10001,10458,10
10001,10459,7
10001,10460,8
10001,10461,10
10001,10462,10
10001,10465,10
10001,10466,12
10001,10467,10
10001,10469,11
10001,10471,11
10001,10472,8
10001,10473,8
10001,10504,30
10001,10506,35
10001,10509,50
10001,10510,29
10001,10512,51
10001,10514,31
10001,10517,38
10001,10520,33
10001,10523,23
10001,10528,21
10001,10530,21
10001,10532,27
10001,10536,39
10001,10538,17
10001,10540,43
10001,10541,44
10001,10546,32
10001,10548,35
10001,10549,34
10001,10550,13
10001,10560,45
10001,10562,30
10001,10566,38
10001,10567,38
10001,10570,28
10001,10573,24
10001,10577,24
10001,10583,19
10001,10589,43
10001,10590,42
10001,10591,23
10001,10595,25
10001,10598,39
10001,10601,22
10001,10603,23
10001,10604,24
10001,10605,22
10001,10701,14
10001,10704,13
10001,10705,12
10001,10707,17
10001,10708,15
10001,10709,17
10001,10710,16
10001,10801,15
10001,10901,27
10001,10918,44
10001,10920,27
10001,10921,44
10001,10924,48
10001,10925,36
10001,10926,39
10001,10932,54
10001,10933,50
10001,10940,53
10001,10949,41
10001,10954,24
10001,10956,27
10001,10960,24
10001,10962,20
10001,10965,21
10001,10976,19
10001,10977,25
10001,10980,33
10001,10981,43
10001,10984,31
10001,10988,49
10001,10990,40
10001,10992,48
10001,10994,24
10001,10996,44
10001,10998,50
10001,11001,15
10001,11003,16
10001,11004,14
10001,11010,17
10001,11020,14
10001,11021,14
10001,11023,14
10001,11030,16
10001,11040,16
10001,11050,16
10001,11101,2
10001,11102,3
10001,11103,4
10001,11105,4
33101,33002,9
33101,33004,19
33101,33008,21
33101,33009,15
33101,33010,6
33101,33012,9
33101,33013,7
33101,33014,11
33101,33015,13
33101,33016,11
33101,33017,15
33101,33018,13
33101,33019,17
33101,33020,17
33101,33021,17
33101,33023,15
33101,33024,17
33101,33025,16
33101,33026,18
33101,33027,17
33101,33028,19
33101,33029,20
33101,33030,27
33101,33032,22
33101,33033,25
33101,33034,30
33101,33037,46
33101,33054,10
33101,33055,12
33101,33060,31
33101,33062,33
33101,33063,33
33101,33064,35
33101,33065,34
33101,33067,36
33101,33068,30
33101,33069,31
33101,33071,32
33101,33073,36
33101,33074,35
33101,33076,36
33101,33077,32
33101,33082,17
33101,33101,0
33101,33109,4
33101,33114,5
33101,33119,4
33101,33122,8
33101,33126,6
33101,33128,1
33101,33129,2
33101,33130,1
33101,33131,1
33101,33132,1
33101,33133,4
33101,33134,5
33101,33135,2
33101,33136,1
33101,33137,3
33101,33138,5
33101,33139,4
33101,33140,5
33101,33142,3
33101,33143,8
33101,33144,7
33101,33145,3
33101,33146,6
33101,33149,6
33101,33152,8
33101,33153,6
33101,33154,9
33101,33155,7
33101,33156,10
33101,33157,15
33101,33160,12
33101,33161,8
33101,33162,10
33101,33163,12
33101,33165,10
33101,33166,8
33101,33167,8
33101,33168,8
33101,33169,11
33101,33170,21
33101,33172,10
33101,33175,13
33101,33176,13
33101,33177,18
33101,33178,11
33101,33179,12
33101,33180,13
33101,33181,9
33101,33182,13
33101,33184,13
33101,33185,16
33101,33186,15
33101,33187,21
33101,33189,17
33101,33190,18
33101,33193,16
33101,33196,18
33101,33197,16
33101,33257,15
33101,33265,12
33101,33266,6
33101,33283,13
33101,33296,13
33101,33301,24
33101,33302,25
33101,33303,24
33101,33304,25
33101,33305,26
33101,33308,29
33101,33309,28
33101,33311,25
33101,33312,22
33101,33313,26
33101,33314,20
33101,33316,23
33101,33317,23
33101,33319,28
33101,33322,26
33101,33323,27
33101,33324,24
33101,33325,24
33101,33326,26
33101,33327,27
33101,33328,20
33101,33330,21
33101,33331,22
33101,33332,23
33101,33334,28
33101,33335,28
33101,33345,27
33101,33351,28
33101,33355,25
33101,33422,57
33101,33424,54
33101,33426,52
33101,33427,39
33101,33428,39
33101,33429,40
33101,33431,42
33101,33432,40
33101,33433,39
33101,33436,52
33101,33437,52
33101,33441,37
33101,33442,37
33101,33443,37
33101,33444,47
33101,33445,47
33101,33454,57
33101,33460,59
33101,33461,59
33101,33462,56
33101,33463,57
33101,33467,57
33101,33474,57
33101,33483,48
33101,33484,47
33101,33486,40
33101,33487,44
33109,33002,12
33109,33004,19
33109,33008,22
33109,33009,15
33109,33010,10
33109,33012,12
33109,33013,10
33109,33014,14
33109,33015,16
33109,33016,14
33109,33017,18
33109,33018,16
33109,33019,17
33109,33020,17
33109,33021,18
33109,33023,16
33109,33024,19
33109,33025,18
33109,33026,20
33109,33027,19
33109,33028,21
33109,33029,23
33109,33030,29
33109,33032,23
33109,33033,26
33109,33034,31
33109,33037,46
33109,33054,12
33109,33055,15
33109,33060,32
33109,33062,33
33109,33063,34
33109,33064,35
33109,33065,36
33109,33067,37
33109,33068,31
33109,33069,32
33109,33071,34
33109,33073,37
33109,33074,35
33109,33076,38
33109,33077,34
33109,33082,20
33109,33101,4
33109,33109,0
33109,33114,8
33109,33119,1
33109,33122,11
33109,33126,9
33109,33128,4
33109,33129,3
33109,33130,3
33109,33131,3
33109,33132,3
33109,33133,6
33109,33134,7
33109,33135,5
33109,33136,4
33109,33137,4
33109,33138,6
33109,33139,1
33109,33140,3
33109,33142,6
33109,33143,10
33109,33144,10
33109,33145,5
33109,33146,9
33109,33149,4
33109,33152,11
33109,33153,7
33109,33154,8
33109,33155,10
33109,33156,12
33109,33157,16
33109,33160,12
33109,33161,9
33109,33162,11
33109,33163,13
33109,33165,13
33109,33166,11
33109,33167,10
33109,33168,10
33109,33169,13
33109,33170,22
33109,33172,13
33109,33175,16
33109,33176,15
33109,33177,19
33109,33178,14
33109,33179,13
33109,33180,14
33109,33181,9
33109,33182,16
33109,33184,16
33109,33185,18
33109,33186,18
33109,33187,23
33109,33189,18
33109,33190,19
33109,33193,19
33109,33196,20
33109,33197,18
33109,33257,17
33109,33265,15
33109,33266,9
33109,33283,16
33109,33296,15
33109,33301,25
33109,33302,26
33109,33303,24
33109,33304,26
33109,33305,27
33109,33308,29
33109,33309,29
33109,33311,26
33109,33312,23
33109,33313,27
33109,33314,21
33109,33316,23
33109,33317,25
33109,33319,29
33109,33322,28
33109,33323,29
33109,33324,25
33109,33325,26
33109,33326,28
33109,33327,30
33109,33328,22
33109,33330,23
33109,33331,24
33109,33332,26
33109,33334,29
33109,33335,29
33109,33345,29
33109,33351,29
33109,33355,26
33109,33422,58
33109,33424,54
33109,33426,53
33109,33427,41
33109,33428,40
33109,33429,40
33109,33431,42
33109,33432,40
33109,33433,40
33109,33436,53
33109,33437,52
33109,33441,38
33109,33442,38
33109,33443,38
33109,33444,48
33109,33445,48
33109,33454,58
33109,33460,59
33109,33461,59
33109,33462,57
33109,33463,58
33109,33467,58
33109,33474,58
33109,33483,48
33109,33484,48
33109,33486,40
33109,33487,44
10001,11201,3
10001,11204,9
10001,11205,4
10001,11206,4
10001,11208,8
10001,11213,6
10001,11215,5
10001,11218,7
10001,11219,7
10001,11223,10
10001,11224,11
10001,11226,7
10001,11228,9
10001,11230,8
10001,11231,4
10001,11232,6
10001,11234,9
10001,11235,11
10001,11236,9
10001,11238,5
10001,11351,9
10001,11355,8
10001,11357,9
10001,11358,10
10001,11359,12
10001,11361,11
10001,11362,13
10001,11364,12
10001,11365,10
10001,11366,10
10001,11367,9
10001,11368,6
10001,11369,6
10001,11372,5
10001,11373,6
10001,11374,7
10001,11375,7
10001,11377,4
10001,11378,4
10001,11379,6
10001,11385,6
10001,11405,11
10001,11411,14
10001,11412,12
10001,11414,9
10001,11415,8
10001,11418,9
10001,11420,10
10001,11421,8
10001,11422,14
10001,11427,12
10001,11428,13
10001,11432,10
10001,11434,12
10001,11435,10
10001,11507,18
10001,11509,18
10001,11510,21
10001,11514,20
10001,11518,19
10001,11520,22
10001,11530,18
10001,11542,21
10001,11549,19
10001,11550,19
10001,11552,18
10001,11553,21
10001,11558,20
10001,11559,16
10001,11561,20
10001,11565,18
10001,11566,23
10001,11568,21
10001,11570,19
10001,11572,20
10001,11576,18
10001,11577,18
10001,11580,16
10001,11590,21
10001,11596,18
10001,11694,14
10001,11702,35
10001,11703,35
10001,11704,33
10001,11706,38
10001,11710,24
10001,11714,27
10001,11715,50
10001,11716,46
10001,11717,39
10001,11720,48
10001,11722,42
10001,11725,37
10001,11727,53
10001,11729,34
10001,11730,42
10001,11731,36
10001,11735,28
10001,11738,50
10001,11741,48
10001,11743,31
10001,11746,32
10001,11749,43
10001,11751,40
10001,11753,24
10001,11754,40
10001,11756,25
10001,11757,33
10001,11758,28
10001,11762,28
10001,11763,53
10001,11764,54
10001,11766,52
10001,11767,44
10001,11768,36
10001,11769,45
10001,11772,52
10001,11773,25
10001,11777,50
10001,11779,46
10001,11782,48
10001,11784,50
10001,11787,42
10001,11788,41
10001,11789,55
10001,11790,46
10001,11791,26
10001,11793,25
10001,11796,46
10001,11797,28
10001,11798,33
10001,11801,25
10001,11803,27
10001,11804,28
10001,11953,55
10001,11967,59
10001,11980,56
10001,12508,52
10001,12512,59
10001,12533,58
10001,12542,59
10001,12543,52
10001,12550,53
10001,12551,54
10001,12553,49
10001,12575,51
10001,12590,58
10001,12771,55
10001,18324,58
10001,18336,56
10001,18343,59
10001,18371,56
10001,18938,59
10001,19054,59
10001,19067,57
-
zipfind
==================
25986,07024,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
32433,10965,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
48008,08560,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
48015,07407,10.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
48190,07083,10.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
49944,07430,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
50778,11577,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
54202,07626,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
54869,33327,30.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
56991,12553,40.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
57274,33029,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
57290,33068,10.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
57301,07024,40.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
57993,33317,10.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
25354,10017,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
26111,11378,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
26364,08840,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
28533,07093,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
30913,06468,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
48309,33330,10.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
51422,10538,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
52990,33032,40.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
53353,33015,40.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
55964,33196,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
57378,33010,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
57736,10577,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
58307,10010,10.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
59334,33182,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
24756,33319,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
26178,11580,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
27209,10590,10.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
28052,33019,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
30535,08831,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
47705,33068,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
48865,11204,10.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
49538,07739,10.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
54421,33029,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
57801,11577,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
24981,10567,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
25447,07095,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
26967,33037,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
27420,07719,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
27432,11766,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
28214,10965,10.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
29539,33029,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
31456,33037,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
46599,33305,10.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
47217,33172,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
47879,07095,10.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
48464,33029,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
50101,33327,40.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
50137,06854,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
50146,06854,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
52856,33135,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
53597,33330,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
54656,33015,10.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
56841,08840,10.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
56843,10466,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
27522,11050,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
29096,07205,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
29115,11105,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
29126,11231,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
32079,10473,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
32109,11040,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
32419,08817,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
49920,11427,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
52169,33064,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
52170,33460,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
52184,33138,10.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
52582,06850,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
52903,33065,10.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
56973,10998,10.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
29411,06611,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
48281,07047,10.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
48758,33126,10.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
54061,11362,40.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
54065,11362,30.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
56713,11549,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
26251,10504,10.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
26686,11558,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
30978,08816,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
32257,33063,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
32592,11374,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
32643,11372,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
43853,33460,10.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
50052,11772,10.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
52004,07871,40.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
52757,11231,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
54110,33460,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
54731,08753,40.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
55470,11727,10.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
57163,11801,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
57431,11427,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
58131,07921,10.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
58448,11232,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
28731,11791,10.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
31128,08837,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
33073,10977,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
45334,10128,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
47562,10549,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
48384,33137,40.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
48438,33126,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
51526,07076,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
51659,33429,30.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
57210,07631,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
57233,07078,10.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
58228,11232,10.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
58902,08816,10.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
28631,33304,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
29117,08544,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
29143,07436,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
29704,06810,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
31106,10033,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
31445,33186,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
40261,33143,10.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
40766,10509,10.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
42499,33186,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
47953,33156,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
48647,33144,10.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
48678,11756,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
50371,33431,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
51343,07701,10.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
53885,07712,10.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
54551,08857,10.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
55672,33146,40.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
58004,08733,40.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
58675,11208,30.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
58941,07726,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
58963,10004,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
59267,33326,10.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
59602,33326,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
25232,33325,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
26137,33189,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
26301,33324,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
28457,11561,40.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
30587,33326,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
33122,33165,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
45479,07726,30.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
47390,33187,40.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
48323,07940,30.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
48717,33156,40.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
49139,10002,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
50540,07305,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
52286,10004,10.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
52683,11420,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
53379,33014,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
54064,10002,30.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
55144,07724,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
55598,33189,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
56320,33178,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
57694,10314,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
58041,10314,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
58760,11572,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
58761,11572,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
58773,07424,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
59686,33314,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
26726,07060,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
30161,11756,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
30227,33155,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
31288,07701,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
31947,10710,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
32313,10015,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
32559,10013,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
32590,33144,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
52054,10001,30.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
53860,11767,10.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
54753,10001,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
56430,10980,10.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
56773,10604,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
25448,11756,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
27909,33175,10.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
29602,33324,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
30093,06810,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
30414,07004,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
30444,33312,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
31473,33144,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
31529,11720,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
32508,33155,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
39938,33432,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
44990,10541,40.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
46587,10014,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
47268,33283,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
48445,33303,30.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
52072,11756,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
52434,10458,10.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
53215,33033,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
54351,10001,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
56200,19067,30.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
58210,07039,30.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
25082,07011,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
25597,33487,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
26524,07642,40.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
27118,33163,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
27145,33067,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
28613,06460,30.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
28647,08807,10.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
32933,33134,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
33183,06877,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
37320,33426,10.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
46777,33185,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
47180,11520,10.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
47615,33185,10.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
51365,10954,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
51402,07013,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
54911,07052,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
54930,11201,10.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
55651,11235,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
55699,33487,40.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
56045,10532,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
25353,11576,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
26105,07421,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
26419,33134,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
28997,07731,10.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
29436,33185,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
29470,18336,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
30042,10011,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
30238,33445,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
30662,07013,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
31669,10011,10.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
32333,10011,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
40989,07450,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
48692,33129,10.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
54836,33109,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
55562,33328,40.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
55998,33436,10.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
57376,33067,30.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
58045,33331,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
58277,33316,10.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
58298,10021,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
25650,08873,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
29254,11102,10.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
31329,10601,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
33423,10954,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
48156,07920,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
49178,07072,40.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
52421,33109,30.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
55801,33328,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
57167,10940,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
27882,11377,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
27902,11694,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
28721,07834,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
30095,07450,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
30802,06484,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
31183,10598,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
31528,10465,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
32512,10011,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
42224,11355,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
46154,33185,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
48460,33328,10.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
48471,10011,10.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
51065,33308,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
52477,06877,10.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
53185,33134,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
55857,08863,40.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
57198,08863,10.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
58271,10021,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
-
zipsupdated
==================
10001,2006-05-17 19:48:00
33101,2007-06-25 15:41:00
33109,2006-06-02 22:32:00
-
I got your data, ddl, and current procedure. I'll see what I can do with it tonight at home.
Any one else want to jump in, please do as you may come up with a different solution than I may.
-
Hi dzigrino,
two points:
first, did you have a look at the transaction log and at tempdb while the procedure ran? if sql server treats this insert as one big transaction that will slow the procedure - you might want to cut the insert in several parts...
second, for your cursorless prodcedure i would change
WHILE EXISTS (SELECT TOP 1 * FROM #zipsic)
BEGIN
SELECT TOP 1 @id = ID FROM #zipsic
...
DELETE FROM #zipsic WHERE ID = @id
END
to
SELECT TOP 1 @id = ID FROM #zipsic ORDER BY ID
WHILE @id IS NOT NULL
BEGIN
...
SELECT TOP 1 @id = ID FROM #zipsic
WHERE ID > @id
ORDER BY ID
END
(no additional write operation during the loop)
hope this helps...
karl
Best regards
karl -
Hi Karl,
Thanks for your comments. This is the first time I have had to optimize (to this much of a degree) anything I have written. I've never even had to figure out how to use the transactions logs and tempdb before, though I've heard of them. I'm off to hit BOL right now as this sounds like something that could definitely make things get slower and slower. Not sure how to force a transaction to end, but I will find out. Is the delete from #zipsic the additional write you are referring to? Would selecting the MIN(ID) require less processing than the order by ID?
BTW, I put an index on the #temp_map_city2zip table, and things definitely sped up overall by a significant amount. They still keep getting slower after starting so I'm hoping figuring out how to make smaller multiple transactions will help. I am also in the process of moving the temp tables outside of the cursor in the cursor version as this seems to be obviously less work.
Also, while trying to use the profiler, I saw an insane number of locks. I guess it was for each row. I was thinking for the temp tables I don't need to lock since this process will be the only one using them. As for the other tables, I am wondering if TABLOCK might be a good balance between speed and availability.
Thanks again to everyone.
-
Lynn, I think you win the grand prize (though I found all the advice exceptionally useful). I think moving the tables out of the cursor did the trick. I was able to insert a respectable average of 212K records per minute without the slow-down. The cursor finished in 14:48. My guess is that the difference between truncating the tables and dropping the tables is what did it. In relation to Karl's insight on the whole thing being one big transaction, dropping the tables must have forced SQL to keep track of all those deleted records that kept accumulating. Maybe this description is not quite on target, but that is my best guess.
Again thanks to everyone. I may try a few more of the suggestions to get the 212K up as high as I can, but I am happy with the current results.
Danny
-
I am glad to here that things are running smoother and faster. I have setup a sandbox with the data you provided, but I haven't had a chance yet to tackle a set-based approach to this process. I will still take a look at this over the next couiple of days (or so) and get back to you.
-
I am writing a stored procedure to populate a table nightly with approximately 2,700,000 records. Each record has a ranking field and total field that must be populated (e.g. 5 out of 25). The rankings are based on groupings of the records. The groups are zip-sic where sic is a category used in the application. Last time I ran the procedure, it took 8 hrs to finish. Would you define this a bit more, please? The reasons you documented in the code identify what you are doing, but not why. And what's with the distance calculation?
Pretend you have no code and you've never seen the code... describe to me (us) what the process is supposed to do and be sure to include some sample output that clearly demonstrates if and when the ranking column is supposed to break and when the total column is supposed to break.
From what I've seen, so far, I see no reason to use a cursor or a While loop... Ranking and grouped running totals on 3 million rows should take just a minute or two. I'm just not sure what you want done and, yes, I'm being a bit lazy about reading code...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)
Viewing 9 posts - 16 through 23 (of 23 total)
You must be logged in to reply to this topic. Login to reply