Check this out with DataAdapter.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi NG members

Has anyone out here tried to carry out some Stress test on dataadapter.fill()
Guys try this

Simple query with 1 or 2 join
Tables not having more than 1K records
Use da.Fill(ds
Bind a table to some grid. No fancy stuff --- You will notice problems here as tables object itself is not created
Use a stress tool to put some load.
Also run this code from separate instance of UI so that you can see actual error generated when you try to bind

Be careful using dataset if your application has many users and there is plenty of load.

If there is any fix to this from microsoft then I would like know it as well

Enjoy testing and thanks in advance for suggestions

Sach
 
Sachy, I do this every day, with well over 1k records, in some instances it
can get as high as 4k, so I'm not sure if that's your problem. moreoever,
this is often done with 3 and 4 table joins including lookups. However, I
am using a DataRelation object to link the tables, I'm not pulling over a
server side join, but that's what DataRelations are meant to address.

What sort of 'stress' in particular are you subjecting it to? We do this in
a scenario with roughly 20-40 users at any given time and don't have any
performance issues worth mentioning, so I'd be interested in seeing what's
causing your problem.

Cheers,

Bill
Sachy said:
Hi NG members,

Has anyone out here tried to carry out some Stress test on dataadapter.fill().
Guys try this.

Simple query with 1 or 2 joins
Tables not having more than 1K records.
Use da.Fill(ds)
Bind a table to some grid. No fancy stuff --- You will notice problems
Click to expand...
here as tables object itself is not created.
Use a stress tool to put some load.
Also run this code from separate instance of UI so that you can see actual
Click to expand...
error generated when you try to bind.
 
Hi Sachy,

Don't see the problem - I've done this 100's of times without difficulty.

Please explain further.

Bernie Yaeger

Sachy said:
Hi NG members,

Has anyone out here tried to carry out some Stress test on dataadapter.fill().
Guys try this.

Simple query with 1 or 2 joins
Tables not having more than 1K records.
Use da.Fill(ds)
Bind a table to some grid. No fancy stuff --- You will notice problems
Click to expand...
here as tables object itself is not created.
Use a stress tool to put some load.
Also run this code from separate instance of UI so that you can see actual
Click to expand...
error generated when you try to bind.
 
Back
Top