Skip to main content
Software Engineering

Return to Answer

Added Microsoft to make it clear what I am talking about
Source Link
George Barwood
George Barwood
  • 499
  • 4
  • 11

I am working on an implementation of SQL in C#, serving simple web pages, and a typical transaction ( which generates a page of HTML ) typically runs in 0.1 ms to 0.5 ms.

So it should be possible. Of course it helps if the SQL is pre-compiled as a stored procedure, and it depends what you are doing.

Another benchmark : it can summarise 5 million rows from a base table in well under one second. Microsoft SQL Server ( running on the same machine, my personal laptop ) is about twice as slow, and dramatically so for adding rows in T-SQL loop ( where it can be 20 times slower ). That's about all the performance comparison I have done so far ( and it may not be "fair" ).

I am working on an implementation of SQL in C#, serving simple web pages, and a typical transaction ( which generates a page of HTML ) typically runs in 0.1 ms to 0.5 ms.

So it should be possible. Of course it helps if the SQL is pre-compiled as a stored procedure, and it depends what you are doing.

Another benchmark : it can summarise 5 million rows from a base table in well under one second. SQL Server ( running on the same machine, my personal laptop ) is about twice as slow, and dramatically so for adding rows in T-SQL loop ( where it can be 20 times slower ). That's about all the performance comparison I have done so far ( and it may not be "fair" ).

I am working on an implementation of SQL in C#, serving simple web pages, and a typical transaction ( which generates a page of HTML ) typically runs in 0.1 ms to 0.5 ms.

So it should be possible. Of course it helps if the SQL is pre-compiled as a stored procedure, and it depends what you are doing.

Another benchmark : it can summarise 5 million rows from a base table in well under one second. Microsoft SQL Server ( running on the same machine, my personal laptop ) is about twice as slow, and dramatically so for adding rows in T-SQL loop ( where it can be 20 times slower ). That's about all the performance comparison I have done so far ( and it may not be "fair" ).

Source Link
George Barwood
George Barwood
  • 499
  • 4
  • 11

I am working on an implementation of SQL in C#, serving simple web pages, and a typical transaction ( which generates a page of HTML ) typically runs in 0.1 ms to 0.5 ms.

So it should be possible. Of course it helps if the SQL is pre-compiled as a stored procedure, and it depends what you are doing.

Another benchmark : it can summarise 5 million rows from a base table in well under one second. SQL Server ( running on the same machine, my personal laptop ) is about twice as slow, and dramatically so for adding rows in T-SQL loop ( where it can be 20 times slower ). That's about all the performance comparison I have done so far ( and it may not be "fair" ).