Ok, the deal goes like this, we have a SQLServer7.0 db that we store BLOBs
(i.e. .doc and .ppt) files in, we use the following code to upload the
files:
RS := fDatabase.OpenRecordSet( ' SELECT * FROM ' + fTableName +
' WHERE ' + fKeyAlias + ' = ' + intToStr(
fId ),
'DLL.MethodName',LOGSWITCH ) as RecordSet;
RS.Update( fContentColumnName, Value );
RS.Close;
The application that uses the code resides on a Citrix box, when connecting
from a NT machine this code rockets along, but run the Citrix application
from a 95 machine and it takes 2min to upload a 40k file.
I am assuming that this is a OS issue but does anyone on the list have any
quick idea's that could make this faster? I.e. a different way to call the
recordset?
Nikolai
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
