Re: Please display the table faster in the datagrid

Tech-Archive recommends: Fix windows errors by optimizing your registry


"cj" <cj@xxxxxxxxxxxxx> wrote in message
news:eGmUVwT6FHA.3804@xxxxxxxxxxxxxxxxxxxxxxx
> Thanks Dmitriy, I did find some 3rd party tools but I'm not ready to
> recommend purchasing them yet. I don't think it'll work for me to try to
> develop this action on my own for all those reason you mention.
>
> I was wondering, if I set up a datatable with the columns the same as the
> VFP table would I be able to use mySQLCommand.ExecuteNonQuery() with a SQL
> command like "Select field1, field2, etc Insert into dt" and it be faster
> that the myFileAdapter.Fill(ds, tableName)? I doubt I have the sql
> command correct but I think you will see what I'm talking about.
>
> It was also mentioned to me to try the odbc drivers instead of the oledb
> drivers.
>

If you are still looking for solution how to retrieve 60 millions records
faster, then forget about it. You definitely can find something, which give
you 10-15% gain in performance in terms of actual data retrieval, but
network traffic and memory usage on workstation will remain the same and it
is not acceptable. You can't populate a grid with 60 million records (which
are, in addition, denormalized version of three tables and thus pretty
wide - with many number of columns) without significant penalty. You will be
even greater penalized, when this application is used by many users
concurrently - you can destabilize entire enterprise with such application.

I don't think ODBC is faster than native OLEDB for SQL server - probably,
just the opposite. As for VFP - I don't know.

If you will implement something that I mention as "virtual" grid - the one
populated on demand, then use of intermediate tables is possible, but hardly
reasonable. You will not be able to avoid those complexities that I
mentioned - all of them remain the same and the need to take care about
intermediate tables is added (you should know when and how to populate them,
when to clear, when to remove, resolve conflicts between users working
concurrently, etc).

Again, I don't know much about .Net. Maybe there is something available
there. But main idea remain the same - you should populate visual elements
with just portion of data (most likely with that portion, which is currently
visible on the screen). Actual implementation depends on functional
requirements and on available tools, and being .Net developer you know these
tools better than me (or ask .Net guys for recommendations).

Dmitriy.


.

Relevant Pages

  • Re: Scripting conditional list box
    ... the drop down boxwon't populate. ... Dim SQL as string ... SQL = "SELECT ApptTime FROM AppointmentTimes WHERE ApptTime not in ... except that you called the query "Time". ...
    (microsoft.public.access.formscoding)
  • Re: Re: Inserting large amounts of data
    ... > I'm using DTS to populate a staging table with raw streams of data (a ... I thought about imbedding the SQL ... Doing the substringing in T-SQL is not the ...
    (comp.databases.ms-sqlserver)
  • Re: Populating date into SQL
    ... datetime field in SQL ... Dim trans As SqlClient.SqlTransaction 'Transaction object ... 'Populate sql ... insertCMD = String.Formatvalues ...
    (microsoft.public.dotnet.languages.vb)
  • IIS 6 Security/Authentication Problem?
    ... One of the .asp pages in this sub-web is set to Integrated Windows ... Authentication so that I can pull the users username using ... This page also makes a databse call to SQL2K to populate some drop down ... which to logon to SQL. ...
    (microsoft.public.inetserver.iis)