<Luis Conception Gonzalez> wrote in message
news:C0D5D083-60FE-4ABE-9D09-742B06E828DE@news.elevatesoft.com...
> Hi, Tim...
>
> Yes, there is a DBgrid attached.
> I'm doing my tests in an empty application. Not DBSys.
> Just a form with a DBGrid, Table, Datasource, Database and Session.
>
> If I unlink the DBGrid Datasource, it takes only 0.6 seconds, BUT I really
> need the DBGrid! Data is entered in it!
> The only trick I found is to disable DataSource on BeforePost and
> re-enable it on AfterPost, taking just 1 second! But I don't know if
> making this change in my real app will affect other events...

I wouldn't make changes without knowing what's going on. Why do you refuse
to use DBSYS to try to research what's going on? Just open the table in
dbsys (which uses a dbgrid, obviously) make any change, post it back (total
investment 5 seconds!). Does it happen instantly? Let's assume it does. So
then start looking at what you're doing different in your grid. I would
suspect it is not the posting that is taking long, it is the redisplay of
posted data. Do you have lookup fields? strange calculated fields?
unoptimized filters? After posting events?

Robert

Luis,

<< Yes, there is a DBgrid attached. >>

Is it a standard TDBGrid component, or a 3rd party grid ?

--
Tim Young
Elevate Software
www.elevatesoft.com

Hi, Tim...

Yes, it is a standard TDBGrid cimponent.
As I said, it is a simple and empty test application with just one DBGrid, Datasource, table, session and database.
No table events. No database events. No session events.
I have tried with indexes active, inactive, no indexes, deleting blob fields from structure, deleting 10 more fields, etc...
Table has only 300 records.

If I deactivate the DBGrid DataSource, it only takes 0.6 seconds.

However, I'm trying to change my app, deactivating datasources when not really needed.

"Tim Young [Elevate Software]" wrote:

Luis,

<< Yes, there is a DBgrid attached. >>

Is it a standard TDBGrid component, or a 3rd party grid ?

--
Tim Young
Elevate Software
www.elevatesoft.com

Luis,

<< Yes, it is a standard TDBGrid cimponent.
As I said, it is a simple and empty test application with just one DBGrid,
Datasource, table, session and database.
No table events. No database events. No session events.
I have tried with indexes active, inactive, no indexes, deleting blob
fields from structure, deleting 10 more fields, etc...
Table has only 300 records.

If I deactivate the DBGrid DataSource, it only takes 0.6 seconds. >>

Please send me the server IP address via private email.  I'll log in using
DBSYS and try to open that table, and see what the situation is.  As I said
before, the records to fill the grid should be read all at once.

--
Tim Young
Elevate Software
www.elevatesoft.com