scrollHeight problems with IE8

scrollHeight property does not work on IE8 and older IE browsers.

The workaround is to call the property before using it.

var tbox = document.querySelectorAll('[id^="transtext"]');

            for (var i = 0; i < tbox.length; i++) {

                tbox[i].style.height = 'auto';

                //put this line to make it work

                tbox[i].scrollHeight;

                tbox[i].style.height = tbox[i].scrollHeight + 'px';

            }

Useful link:

http://www.atalasoft.com/cs/blogs/davidcilley/archive/2009/06/23/internet-explorer-textarea-scrollheight-bug.aspx

Site on a stick

Today I explored the idea of getting Apache webserver on a memory stick using XAMPP software.

http://www.todayinwindows.com/2011/08/how-to-run-asp-net-on-xampp/

 

The problem with this approach is that an ASP website will need to be ported to run on apache.

To accomplish this we will have to use additional tools like:

http://sourceforge.net/projects/mod-aspdotnet - this looked outdated and probably is no longer supported

http://www.mono-project.com/ASP.NET - this should work, but not sure of commercial licencing.

 

To avoid this, its better to use IIS Express 7.5.

http://leekelleher.com/2011/01/15/umbraco-on-usb-usin-iis-express-and-sqlce4/

 

The other problem is how to install SQL server on the memory stick. It is possible to install the data file on the memory stick, but the software will still need to installed on the native machine.

It is possible to migrate SQL server to another database like SQL Server CE or MySQL and then port it to memory stick.

 

SQL CE does not support Stored procedures. So using SQL CE will imply rewriting all SPs in code using LINQ.

 

The other option is to install Windows 8 operating system on the memory stick.

http://www.microsoft.com/en-us/windows/enterprise/products-and-technologies/devices/windowstogo.aspx

You can then install IIS express and SQL Server express on the portable operating system.

Improving performance by using Snapshot isolation level

While working on the performance tuning on the my website, I was getting the following error:

Transaction (Process ID XXX) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

To reduce this deadlock, I changed the default isolation level of the database to Snapshot.

ALTER DATABASE dBname

SET ALLOW_SNAPSHOT_ISOLATION ON

ALTER DATABASE dBname SET SINGLE_USER WITH ROLLBACK IMMEDIATE;

ALTER DATABASE dBname SET READ_COMMITTED_SNAPSHOT ON;

ALTER DATABASE dBname SET MULTI_USER;

 

I then changed the webservice calls to the database, such that the transaction scope for all read operations is set to IsolationLevel.Snapshot

 

var _transaction = new TransactionScope(TransactionScopeOption.Required, new TransactionOptions { IsolationLevel = IsolationLevel.Snapshot, Timeout = TimeSpan.FromMinutes(1) });

More information on snapshot isolation level can be found here:

http://msdn.microsoft.com/en-us/library/tcbchxcb(v=vs.80).aspx

It implements optimistic concurrency – such that user can read the last committed data, while its being modified.