在LoadRunner中使用MySQL替代VTS

 

Richard Bishop在《Using MySQL instead of VTS for LoadRunner》這篇文章中介紹瞭如何使用MySQL替代VTS：

http://www.bish.co.uk/~richardmjbishop/index.php?option=com_content&view=article&id=89%3Ausing-mysql-instead-of-vts-for-loadrunner&catid=34%3Arecent&Itemid=1

 

VTS（Virtual Table Server）用來解決跨指令碼測試資料共享的問題，但是存在很多缺點，例如：

• VTS can only read in data one row at a time. Queries must then be written in LoadRunner using C code to determine whether the data is suitable for use. This is inefficient when compared to SQL queries which execute on the server and can return data directly to the vUser. 
• VTS is not officially supported by HP (and it wasn't supported by Mercury). MySQL isn't supported either, but MySQL is well documented on the Internet and there is an established user community as well as large numbers of people familiar with SQL syntax.
• VTS is an in-memory database and needs to import data before a test and export data to file before it is shut down. This makes it very easy to accidentally close VTS before data is saved and lose your test data. MySQL and other databases automatically save the database tables when they shut down which reduces the risk of this occurring.

 

 

使用MySQL可以很好地解決這些問題，關於具體如何在LoadRunner中連線MySQL，可參考（提供了一個MySQL連線的DLL以及一些使用樣例）：

http://www.bish.co.uk/forum/index.php?topic=50.msg60#msg60

 

 

 

VTS的內容請參考：

http://www.wilsonmar.com/1mercvts.htm

http://www.myloadtest.com/mercury-virtual-table-server/

 

更多關於LoadRunner連線MySQL的內容請參考：

http://www.myloadtest.com/connecting-to-a-mysql-database-with-loadrunner/