I wanted to perform some load testing of my app. And for which I had to insert some dummy data into a SQL table. Since we wanted to put in maximum data into the fields, it followed that each of the varchar fields should have data with its size limit. Instead of the usual dummy data, I put in some thought to come up with this instead. Am sharing this since I thought this was nice. :)
I didnt come up with the size limits, just the values. The last one is a 6-digit 0-prefixed number that is used to store a million possible values.
First Name | 16 characters | MyFirstNameIsBig |
Last Name | 16 characters | MyLastNameIsLong |
Address1 | 30 characters | My Address1 field is humongous |
Address2 | 30 characters | My Address2 field is huge too! |
City | 30 characters | I live in a pretty cloudy city |
State | 30 characters | I'm in a const state of denial |
Postal Code | 14 characters | what zip code? |
Email Address | 46 characters | writingCodeCanBeFunIfUKnowHow000000@iMGeek.com |
I didnt come up with the size limits, just the values. The last one is a 6-digit 0-prefixed number that is used to store a million possible values.
No comments:
Post a Comment