RE: How to efficiently create test data?
wuli81_at_hotmail.com
Date: 07/21/04
- Next message: John: "Re: db_owner role in SQL 2k"
- Previous message: Carl Carlson: "How to efficiently create test data?"
- In reply to: Carl Carlson: "How to efficiently create test data?"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 20 Jul 2004 18:44:01 -0700
use bcp ,but you need generate your test data before.
"Carl Carlson" wrote:
> Hi,
>
>
>
> I want to learn about performance tuning in SQL and therefore need some test
> data. I thought about inserting data in a table as follows:
>
>
>
>
>
> This approach unfortunately performs very badly and I already got stuck by
> creating my test data :-(
>
>
>
> declare @i int
>
> declare @j int
>
> declare @k int
>
> declare @l int
>
> declare @counter int
>
>
>
>
>
> set @i = 65
>
> set @j = 65
>
> set @k = 65
>
> set @l = 65
>
> set @counter = 0
>
>
>
> while @i < 91
>
> begin
>
> while @j < 91
>
> begin
>
> while @k < 91
>
> begin
>
> while @l < 91
>
> begin
>
> insert into DummyTable1
> (EmpId, EmpName) values (@counter, char(@i) + char(@j) + char(@k) +
> char(@l))
>
> set @l = @l +1
>
> set @counter = @counter + 1
>
> end
>
> set @l = 65
>
> set @k = @k +1
>
> end
>
> set @k = 65
>
> set @j = @j +1
>
> end
>
> set @j = 65
>
> set @i = @i +1
>
> end
>
>
>
>
>
> Can anybody help by telling me hot this can be done better?
>
>
>
> Thank you
>
>
>
- Next message: John: "Re: db_owner role in SQL 2k"
- Previous message: Carl Carlson: "How to efficiently create test data?"
- In reply to: Carl Carlson: "How to efficiently create test data?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
