perfs perfs perfs!

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

Guest

Hello everyone,

I made a very basic app: a main window with menus. Click on menu opens
another window with a datagrid and a close button. I bind this datagrid to a
dataset which gets its data from a simple select on a SqlCe DB.

Why is this so long? It takes average 2 secs to get everything!! And I'm
talking about 15-20 records here on the datagrid.

Anyone knows how to make this 0 seconds?

Thanks,
Sitar.
 
Sitar,

A couple of suggestions:
1. make sure your SELECT statement uses an index on the table in SQL CE
2. use a SqlDataAdapter to populate the dataset that your datagrid is bound
to
3. incur the cost of loading/populating the form with the datagrid only
once -
make that form a singleton and after it is instantiated the first time,
subsequent
requests to show that form should use the same cached instance to display
the
form.

-Darren
 
What kind of device are you performing your tests on?

We have had tremendous performance problems with .NET CF on devices
with Intel PXA 25x processors running PocketPC 2002.

Upgrading these devices to PPC2003 solved all our performance problems!
 
Hi Strider,

It's a Psion Teklogix Netbook Pro win winCE 4.2
The processor's an Intel 400MHz XScale PXA 255

Sitar.

___
 
Darren,

Actually I had deleted the table and pulled it again without indexes. As my
original table had indexes I did not double check...
It's *way* faster now!

Thanks.
Sitar.
 
Back
Top