🚀 go-pugleaf

I don't know if this helps or not, but first:
What version of BCB, OS, DB type, MDAC?

"Sara T." <sarana@infoquest.co.th> wrote in message
news:404fcc0a@newsgroups.borland.com...
> When I use class TADOQuery to connect to retrieve or update in database,
it
> often eats memory and take a lot of cpu (around 90-100%) per times. What
is
> going on ? and How can I eliminate this problem or reduce memory
management
> ?
>
> Following is some part of my using this class:
>
> TADOQuery *ADOQuery = new TADOQuery(NULL);
>
>

Leave these two out.  The query can't readily be prepared because it doesn't
have an SQL statement yet and is not connected to the DB.

> ADOQuery->ParamCheck       = false;
> ADOQuery->Prepared         = true;
>
> ADOQuery->ConnectionString =  m_strConnectionString;
> AnsiString strSQLString;
>
> strSQLString = "SQL Statement to insert data to database"
>
> ADOQuery->SQL->Clear();
> ADOQuery->SQL->Add(strSQLString);
> int iSuccess=ADOQuery->ExecSQL();

How long does it take to execute?

- Arnie


>
> delete ADOQuery;
>
>
>