Re: Give me solution

When form show, I've executed: SELECT TOP 1 * FROM TDAV. So This can be
assumed that amount record will surely 1. But it is still slow. And what is
the meaning of normalized?


"Kevin Frevert" <kevin@xxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:4313230b$1@xxxxxxxxxxxxxxxxxxxxxxxxx
> 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?
> >
> >
>
>


.