Re: Give me solution

Adi,

How many records are you returning to the client? What does the SQL look
like (how are you returning the data to the client)? Do you really need to
return all 200 fields? Why does the table have 200 fields? Can the table
be normalized?

krf

"Bpk. Adi Wira Kusuma" <adi_wira_kusuma@xxxxxxxxxxxx> wrote in message
news:43131c1c@xxxxxxxxxxxxxxxxxxxxxxxxx
> I use ADO to connect sql server 2000. I make form to append, show, delete
> data (form entry). data that I access have 200 field + 1 field image. To
be
> my problems is when data is showed on form, very slow (about 5 second at
> proccessor 1.8 GHz). To show data on form, I use Data Control (Like
DBEdit).
> Can I quicken the showing data process? or Has its condition been maximun
> speed?
>
>


.

Relevant Pages

  • Re: Dont understand what version of SQL to install
    ... I'm talking about developing and testing databases for my client and ... To my XP, I can add SQL Developer 2008 to develop (I guess I should say, ... So I can use SQL Developer 2008 to create a database in standard 2005, ... installed on Client OSs such as Windows Vista. ...
    (microsoft.public.sqlserver.setup)
  • Re: DataSet.GetChanges() in RowChanged(DataRowAction.Add)
    ... have you considered SQL Express and use ... > I realize now that I didn't describe well how the client application is ... > Framework installed on the client machine, but not any SQL Server). ... > 20 tables in different relations with eachother in the database, ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Oracle 10g2 LIKE operator and case-insensitive issues
    ... SQL> CREATE INDEX IDXTESTCASE ON AUTENTI; ... Predicate Information: ... 338 bytes received via SQL*Net from client ... sorts (memory) ...
    (comp.databases.oracle.server)
  • Re: Oracle 10g2 LIKE operator and case-insensitive issues
    ... SQL> CREATE INDEX IDXTESTCASE ON AUTENTI; ... Predicate Information: ... 338 bytes received via SQL*Net from client ... sorts (memory) ...
    (comp.databases.oracle.server)
  • Re: Oracle 10g2 LIKE operator and case-insensitive issues
    ... SQL> CREATE INDEX IDXTESTCASE ON AUTENTI; ... Predicate Information: ... 338 bytes received via SQL*Net from client ... sorts (memory) ...
    (comp.databases.oracle.server)