Tema: Performance test results (kb)
Autorius: Jornada Del Muerto
Data: 2010-08-12 16:27:12
Testas atliktas ant MSSQL 2005 Express, Siunciu sql skripta prie reply

---------------------------------------------------------------------------------------------------
--- TESTS STARTING 1000000 of cycles
---------------------------------------------------------------------------------------------------
method: cast(floor(cast(getdate() as float)) as datetime): 1570 /[2010-08-12 16:25:10.063]-[2010-08-12 16:25:11.633]
method: DateAdd(dd, 0, DateDiff(dd, 0, getdate())): 1236 /[2010-08-12 16:25:11.633]-[2010-08-12 16:25:12.870]
method: DateAdd(dd, 0, DateDiff(dd, 0, getdate())): 2373 /[2010-08-12 16:25:12.870]-[2010-08-12 16:25:15.243]
---------------------------------------------------------------------------------------------------
 Time in MS, FLOOR=1570ms, Datediff=1236ms, CAST CHAR=2373ms
---------------------------------------------------------------------------------------------------

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)
---------------------------------------------------------------------------------------------------
-- Best result is: select DateAdd(dd, 0, DateDiff(dd, 0, getDate()))
---------------------------------------------------------------------------------------------------
Q: PostgreSQL ir backslashErnikas2010-08-16 17:24
+VS2010 solution openSaulius2010-08-16 15:02
+Regex validationBamba2010-08-12 17:03
+oracle recursive triggerledasl2010-08-12 14:58
-MSSQL2000 DATETIME --> DATEJornada Del Muerto2010-08-12 14:29
Re: MSSQL2000 DATETIME --> DATErl2010-08-12 16:05
Re: MSSQL2000 DATETIME --> DATE2x502010-08-12 15:05
Re: MSSQL2000 DATETIME --> DATEJornada Del Muerto2010-08-12 15:20
Re: MSSQL2000 DATETIME --> DATE2x502010-08-12 15:23
Re: MSSQL2000 DATETIME --> DATEDream-Colored Bunny2010-08-12 15:31
Re: MSSQL2000 DATETIME --> DATEJornada Del Muerto2010-08-12 15:35
Re: MSSQL2000 DATETIME --> DATE2x502010-08-12 15:46
Performance test results (kb)@Jornada Del Muerto2010-08-12 16:27
Re: Performance test results (kb)Laimis2010-08-12 16:55
Re: Performance test results (kb)Jornada Del Muerto2010-08-12 17:01
Re: Performance test results (kb)zZz2010-08-13 10:27
Re: Performance test results (kb)Jornada Del Muerto2010-08-13 10:43
Re: Performance test results (kb)Laimis2010-08-13 20:34
Re: Performance test results (kb)Jornada Del Muerto2010-08-14 10:45
Re: Performance test results (kb)@Jornada Del Muerto2010-08-12 16:32
Re: MSSQL2000 DATETIME --> DATEJornada Del Muerto2010-08-12 14:31
+ASP.net kokie kontrolaiSaulius2010-08-11 13:33
+MSSQL rodo ne visus dependenciesJornada Del Muerto2010-08-08 13:16
+Paslepti swf, jei nera instaliuotas flash?System2010-08-07 13:33
+Win7 x64 trablas su MySQL instaliavimuVinetu2010-08-06 18:55
+Q: Visual Studio 2010 performancezZz2010-08-05 14:02
Q: Emailų nuskaitymasGiedrius 2.52010-08-05 09:23
+JavaScript automatinis testavimasBraunikas <labai @ bais . us>2010-08-04 19:03
ASAP ClickOnce ir Signed assemblyJornada Del Muerto2010-08-02 17:32
+ASP.net ajax ir nepkraunamas GridviewklevoLapas2010-07-22 15:15
+Kas galetu pagelbeti su kurimutom2010-07-19 20:13
+formos elementų listasS.2010-07-19 11:42
+100 formųS.2010-07-19 11:32
+Q: SOAP envelopeMauzer2010-07-16 09:31
+e-bankaievaldas2010-07-15 22:00
+Pakonsultuokit apie MySQLNicMC2010-07-15 15:28
+DiapazonaiJornada Del Muerto2010-07-15 13:26
SAp'o reference manual gal pas ka yra?Sail2010-07-15 08:28
+radau skelbimaledasl2010-07-14 18:49
+.net 2.00 asynchronous webservices accessJornada Del Muerto2010-07-13 14:24
+(My)SQL online training?VA2010-07-12 15:57
+delphi ar c++AMB2010-07-09 15:37
+maza apklausfakeID2010-07-08 12:54
+WEB reloudinimasIF2010-06-30 13:44
+.NET tipai + UI + MSSQL moneyJornada Del Muerto2010-06-30 13:27
+req: sarasas firmu dirbanciu su .netfakeID2010-06-29 13:33
+Zodziu sakymasValdas2010-06-29 08:01
+Pataisa Delfi 7 projektukuikrx2010-06-28 23:22
+Access 2007 VBA klausimukasGedikas2010-06-26 13:04
+C++ compilerlover2010-06-24 11:37
Emacs, grep, koduotėsLaimis2010-06-20 18:16
+Q: Excel hyperlink convert to textMinVodai2010-06-17 08:22
+Q: slaptas chatinimasErnikas2010-06-15 11:39
+mssql ilgiaiS.2010-06-14 13:54
+Pakomentuokit reikalavima uzsakovobooraz2010-06-11 14:22
MSSQL Funkcija i OpenQuery?bala nemate2010-06-10 11:15
+Kaip vadinasiS.2010-06-09 10:47
+SMS rate'asflegmatoid2010-06-09 10:36
+excelio (arba OpenOffice calc) klausimasnagi kagi2010-06-07 23:51
+REQ: Java ebookVaidaskz2010-06-04 12:59