Slowness in Selenium...

I’ve spent the day profiling trying to figure out why our RemoteWebDriver usage of Winium.Desktop is so much slower than just running the tests straight through Winium.Cruciatus. The profile yielded that TCPSocket#initialize was the culprit, strange, opening a socket shouldn’t...

SQL query statistics

This is no work of mine but I wanted to highlight it since it´s such a good thing to utilise when optimizing your database and queries. PgSQL SELECT SUBSTRING(qt.text, (qs.statement_start_offset/2)+1, ((CASE qs.statement_end_offset WHEN -1 THEN DATALENGTH(qt.text) ELSE qs.statement_end_offset...

SQL Bottlenecks

In our environment we´ve got a heavily loaded SQL Server as a trunk in the system. Most systems look like this and sooner or later you will probably want to troubleshoot bottlenecks in this database. From a nice fellow at Microsoft we got handed the scripts from Jimmy May´s blog that gives us...

Table variables in S...

Stuck without writing rights in a big database? Only allowed to dbo_reader? Then this baby is for you: PgSQL DECLARE @myTable AS TABLE (rowid int, name varchar) 1 DECLARE @myTable AS TABLE (rowid int, name varchar) This neat little row can be used instead of temp-tables to store subsets of...

Table size

When using large databases it might be interesting to keep an eye out on what of your tables that actually consumes all that disk. There´s a lot of resources on this out there but I thought I´d repeat it anyways since its such a neat little thing: PgSQL EXEC sys.sp_spaceused 'thetable' 1 EXEC...

Measure milliseconds...

Gudday These days I´m doing a lot of lowlevel performance testing and sooner or later you always end up checking your code performance against the database performance and this time I was chasing milliseconds. So, here I am with some sql wanting to check exactly how much time it takes to...