| Subject | Re: [IBO] is it my ib_query or ib_grid is slow? |
|---|---|
| Author | Daniel Rail |
| Post date | 2003-08-06T03:17:18Z |
Hi,
At August 6, 2003, 00:06, james_027 wrote:
UPDATE TABLE SET FIELDA=FIELDA+100
This should be a lot quicker.
Accessing a RDBMS in the same way you would Paradox, is not always the
most efficient way. Sometimes, you have to learn what can be done
natively with the RDBMS.
--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)
At August 6, 2003, 00:06, james_027 wrote:
> Can anyone address to this issue?What about simply using the following SQL statement:
UPDATE TABLE SET FIELDA=FIELDA+100
This should be a lot quicker.
Accessing a RDBMS in the same way you would Paradox, is not always the
most efficient way. Sometimes, you have to learn what can be done
natively with the RDBMS.
--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)