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
|
DECLARE @D DATETIME
DECLARE @i INT
DECLARE @j INT
DECLARE @i1 INT
DECLARE @i2 INT
DECLARE @i3 INT
DECLARE @i4 INT
DECLARE @Dummy1 INT
DECLARE @Dummy2 INT
DECLARE @Dummy3 INT
DECLARE @Dummy4 INT
DECLARE @nbtest INT
DECLARE @word nvarchar(50)
SET @i1 = 0
SET @i2 = 0
SET @i3 = 0
SET @i4 = 0
SET @Dummy1 = 0
SET @Dummy2 = 0
SET @Dummy3 = 0
SET @Dummy4 = 0
set @nbtest = 100
SET @D = GETDATE()
SET @i = 0
WHILE @i < @nbtest
BEGIN
set @word = NEWID()
SELECT @Dummy1 = COUNT(*)
FROM test
WHERE idclub IN (0, 1) AND LEFT(@word, len(filepath)) = filepath
SET @i = @i + 1
END
SET @i1 = DATEDIFF(second, @D, GETDATE())
SET @D = GETDATE()
SET @i = 0
WHILE @i < @nbtest
BEGIN
set @word = NEWID()
SELECT @Dummy2 = COUNT(*)
FROM test
WHERE idclub IN (0, 1) AND @word LIKE filepath + '%'
SET @i = @i + 1
END
SET @i2 = DATEDIFF(second, @D, GETDATE())
SET @D = GETDATE()
SET @i = 0
WHILE @i < @nbtest
BEGIN
set @word = NEWID()
SELECT @Dummy3 = count(*)
FROM test AS T1
INNER JOIN
(SELECT nb, LEFT(@Word, nb) AS sWord
FROM Tally
WHERE nb <= len(@Word)) AS T2
ON T2.sWord = T1.filepath
WHERE idclub IN (0, 1)
SET @i = @i + 1
END
SET @i3 = DATEDIFF(second, @D, GETDATE())
SET @D = GETDATE()
SET @i = 0
WHILE @i < @nbtest
BEGIN
set @word = NEWID()
SET @j = LEN(@word)
while @j > 0
begin
SELECT @Dummy4 = COUNT(*)
FROM test
WHERE idclub IN (0, 1) AND LEFT(@word, @j) = filepath
IF @Dummy4 = 1
begin
break
end
SET @j = @j - 1
end
SET @i = @i + 1
END
SET @i4 = DATEDIFF(second, @D, GETDATE())
SELECT @i1 "Left + Len", @i2 "Like", @i3 "Tally", @i4 "PL"; |