beyondrelational.com

Getting Started with ASP.NET MVC - Part 6: ASP.NET MVC and Entity Framework

First Time? You can support us by signing up. It takes only 5 seconds. Click here to sign up. If you already have an account, click here to login.

TSQL Challenges


Subscribe By Email

Contact US

Pushing database changes needn't be hard work with SQL Compare

Top Winners

	leszek_g	232
	Stefan_G	176
	dishdy	106
	malpashaa	101
	Mark	86
View all

Winning Solutions

Here is the list of solutions that passed the Load Testing for TSQL Challenge 39 - Calculate Gross Profit by Item using FIFO method. Here is the script used to generate the test data.

#	Author	Reads	Writes	CPU	Duration (Sec)	Read Rank	Write Rank	CPU Rank	Duration Rank	Combined Rank
1	Muhammad AlPasha	107809	349	7706	7.0516	3	5	2	2	12
2	bret warnick	252093	347	19750	17.8718	4	4	10	10	28
3	leo ruzin	443144	864	7953	7.2202	12	13	3	3	31
4	R Hansen	746023	538	16817	15.1495	16	6	6	4	32
5	Lourens van Schalkwyk	746030	538	16754	15.3359	17	6	5	6	34
6	Stefan G	744228	1298	2536	2.4911	15	19	1	1	36
7	Siva Prasad Vundavalli	746288	538	16966	15.4369	18	6	8	7	39
8	Stefan G	424566	1140	9796	18.6519	7	18	4	11	40
9	Mingjie Liu	436148	346	28401	25.5747	9	3	17	18	47
10	Wattana Saelim	436146	346	29505	26.2659	8	3	18	19	48
11	Stefan G	1081924	828	16966	15.2931	27	11	8	5	51
12	Antony Clark	909959	703	21631	19.7503	21	9	11	12	53
13	Richard Romley	436150	346	31468	28.1894	10	3	20	20	53
14	Richard Romley	436447	346	31194	28.2890	11	3	19	21	54
15	Dalibor Margotic	328169	248	38445	34.3500	6	2	23	24	55
16	Lutz Mueller	1275	0	43789	40.0445	1	1	26	27	55
17	Otto Csatari	909958	703	21778	19.9979	20	9	12	14	55
18	Dalibor Margotic	436146	346	36866	32.9215	8	3	22	23	56
19	richard harper	436150	346	31774	28.5696	10	3	21	22	56
20	bret warnick	963522	1126	16851	15.5513	24	17	7	8	56
21	Dalibor Margotic	328168	248	38513	34.6408	5	2	24	25	56
22	jonathan roberts	910300	701	21846	19.9099	22	8	14	13	57
23	Pulastya Mitra	910301	703	21842	19.9995	23	9	13	15	60
24	Otto Csatari	1061472	1422	17375	15.9185	26	20	9	9	64
25	jonathan roberts	994488	1113	22305	20.3216	25	16	15	16	72
26	Leszek Gniadkowski	9550	0	106224	105.3656	2	1	34	39	76
27	phil dutton	448890	0	110629	99.1735	13	1	35	35	84
28	yunus simjee	1190184	1473	23802	21.3530	30	21	16	17	84
29	meierruth michael	448890	0	110745	99.4507	13	1	36	36	86
30	dave repton	448890	0	112314	100.8250	13	1	37	37	88
31	Hans Stuer	448890	0	115615	103.5741	13	1	38	38	90
32	Powichrowski Marek	480588	0	127743	114.4887	14	1	41	42	98
33	carlos benito	480588	0	128307	115.0446	14	1	42	43	100
34	Jasper Ziller	1563711	1109	54313	50.1669	34	14	28	29	105
35	Chaitanya Panduga	1086754	731	86087	76.6318	28	10	33	34	105
36	Powichrowski Marek	833822	614	123019	111.6518	19	7	39	40	105
37	Leszek Gniadkowski	1563151	1111	66035	60.5059	32	15	29	31	107
38	Stanislav Vorobiev	1906181	1712	41708	37.3355	35	22	25	26	108
39	R Hansen	1563153	1113	66160	59.7316	33	16	30	30	109
40	Leszek Gniadkowski	1563149	1111	66793	61.0717	31	15	31	32	109
41	meierruth michael	2528300	1725	49592	44.8814	36	23	27	28	114
42	Madhangi Ramasamy	1563153	1113	73205	66.8548	33	16	32	33	114
43	Powichrowski Marek	1171120	859	124507	112.5030	29	12	40	41	122

Note that the challenges are 'always ON', which means that you can submit a solution at any time. You can submit a new solution even after the results are published. If your solution is disqualified due to one of the reasons given above, you can re-submit a new version of the challenge at any time.

Never submitted a solution? Or got a new/different version? Submit it

Test Machine Configuration

OS:Microsoft Windows Vista Home Premium Edition, English
Processor: Intel Core 2 Duo T7250, 2.0GHz, 800Mhz, 2M L2 Cache
Memory: 2 GB
System Type: 32 Bit Operating System
SQL Server Version: SQL Server 2008 R2

Not Happy with the configuration or Test Data?

Give us access to a SQL Server instance running on a server with a different configuration and we can run the tests there.
Suggest alternate load testing data and we will be happy to redo the testing with your data.
Contact us