Re: Performance problem in sql ce

Hi Joker,
I am getting what u want to say by touching smallest number of records
possible.
But the requirement demands many records in one shot (which we r showing on
grid on UI) which depends on many tables with many filter criterias. U can
imagine we have one whole screen for just selecting filter criterias based on
differnt tables.

Initial quey was slow because we also developing similar app in website and
i thought that this query which takes less than 1 sec in sql server 2005 will
execute in acceptable limit in sql ce.

"joker" wrote:

He may be "leveraging" the indexes, but the end desire is the same.
To touch the smallest number of records possible while getting the
ones you want in a timely manner.

I'm not really suggesting abandoning sqlce (it was sarcasm), I just
think he went from one extreem (mega joins in a single query) to the
other (perform all the joins in app. code).


.

Relevant Pages

  • Re: Performance issue after coverting from Framework 1.1 to 2.0
    ... I think that I encountered the same problem: A large program with Framework ... the SQL Server for the dev database. ... when you deploy the app on a different machine where the SQL Server is no ... app was fine on the dev machine. ...
    (microsoft.public.dotnet.framework.performance)
  • Re: C5 woes. How stable is VFP really?
    ... After that I close the SQL server cursor and work with my manual cursor instead. ... a VFP9 app on a really old machine ... app was under more "pressure", VFP showed ...
    (microsoft.public.fox.programmer.exchange)
  • Re: Webservices - the way to go...?
    ... about your lack of secure network connectivity your between a rock and a ... To summarize the posts so far: you have a winform app. ... using a webservices data layer to handle all the database interactions. ... Upgrade your database to SQL Server. ...
    (microsoft.public.dotnet.general)
  • Re: Is SQL Server the right platform?
    ... In some cases my App is downloaded and purchased by a single user and both ... presumably attached to SQL Server or SQL Server Express. ... using the Compact Edition, can the Compact Edition database later be moved ... msi which can install the prerequisits required. ...
    (microsoft.public.sqlserver.setup)
  • Re: New to .Net
    ... a copy of Pro although technically you can build apps without it. ... "Paul Ilacqua" wrote in message ... I just need to get the syntax to build a VB.NET - SQL Server ... >> ui and do things pretty much like a full framework app. ...
    (microsoft.public.dotnet.framework.compactframework)
Loading