This particular video demonstrates how to use the database explorer within Visual Web Developer to create new tables, enter data, and build a simple three-tier data access app against it.
I’d also strongly recommend checking out the great ASP.
2) Table: user_profile Fields: user_id, option, value user_id: 1 option: profile_image value: /uploads/12/and user_id: 1 option: questions_answered value: 24 Hope this helps, Paul.
As you can imagine I'm a little wary to make a table with 200k rows and 100 columns. one with the most used and searched columns and one with the rest (and bulk) of the columns.
But this lead to big synchronization problems between the two tables.
The first thing that I would do about this is to create a table with 1 mln rows of dummy data and test some typical queries on it, using a stress tool like .
It will most probably turn out that it performs just fine - 1 mln rows is a piece of cake for mysql.
In my case, attribs could have from 3 to 130 chars.
Also, the most certainly suffer from the same assumption.
NET 2.0 Data Tutorials series on the net website which now includes 23 unique tutorials that walkthrough how to create three-tier data access applications using ASP.
NET 2.0 (they cover everything from creating a new DAL, creating master/details reporting UI, creating data entry and editing pages, implementing optimistic concurrency, etc).
Profile related information can go in its own table.
This will be an infinitely expandable table with a key = val nature.
There community has currently 200k users and is expected to grow to 500k-1mil in the next one or two years.