Devart Forums

Ikar

Try to set global variable __UseUpdateOptimization to False.

Ikar

Try to set OnDrawDataCell event handler:

procedure TFcartas.GridDrawDataCell(Sender: TObject; const Rect:  TRect; Field: TField; State: TGridDrawState);
begin
  if gdFocused in State then begin
    OLEDBGrid.Canvas.Brush.Color := clRed;
    OLEDBGrid.Canvas.Font.Color := clWhite;
    OLEDBGrid.Canvas.font.Style := [fsBold];
  end;

  OLEDBGrid.DefaultDrawDataCell(Rect, Field, State);
end;

Ikar

Do you need to keep your data safety? If absolutely no need, then you can still use this. In other cases we recommend to use different usernames. And maybe try to look at SSH-tunneling etc.

Ikar

You are right. This behavior is not implemented in the current MyDAC version. Maybe we will add this feature in the next MyDAC version.

Ikar

Thank you for the example.
We reproduced the problem. The problem is in Borland SqlExpr code. To avoid it you should use

Code: Select all

  ParamByName('paymentAmount').AsBCD := 5.00 ;

instead of

Code: Select all

  ParamByName('paymentAmount').AsCurrency := 5.00 ;

Ikar

> The first, i'm trying to looking for a MySQL server in a intranet

Try to count connection time from other MySQL clients. For example, from command-line mysql.exe tool.

> About the skip-name-resolve
> and it works at the same speed

Try to execute SHOW VARIABLES statement to check actual skip-name-resolve value.

>I set the connection TimeOut to 2 seconds to make it faster

Setting small TimeOut value doesn't increase performance. It just sets time to raise an exception.

> The second problem is using PHP
> the problem maybe in the BMP format

Most possible the problem is in PHP code. Try to ask this question on PHP-specific forums.

Ikar

> The first, i'm trying to looking for a MySQL server in a intranet

Please try to set Connection.Server in IP format. Also try to set skip-name-resolve server variable. You can read more about it in MySQL Reference Manual

> The second problem is using PHP

Please check BMP uploading using MyDacDemo (Pictures Frame). Do you see any problem?

Ikar

If you use MySQL from only one thread simultaneously, then your current strategy is correct.

Ikar

We haven't received your email.
Please resend one to ikar*crlab*com.

Ikar

Thank you for information.
We have reproduced the problem and fixed it.
This fix will be included in the next build of SDAC.

Ikar

Can you connect to this server from localhost (MyConnection1->Server = "localhost")?
If yes you should create 'root@%' user at the server.

Ikar

This problem is in the field naming. To avoid it, you should set properties for "level" fields to default values (or just recreate these fields) and create additional lookup field with FieldName, for example, "level_l".

Ikar

> Help also says that if an unprepared query is executed
> it is automatically prepared. If that's the case, what's the benefit of
> preparing it in the first place?

Thank you for information. We will review these topics to make them more informal for MySQL users. In MySQL case preparation is not of necessity.

Brifely, we recommend to try preparation on your environment (DML, data, network, etc.) and check time of execution queries.

You can read more details about preparation in MySQL Reference Manual.

Ikar

Follow the following steps:
1) Uninstall DbxSda.
2) Search for dbexpsda*.dll files at your HDD and delete them.
3) Install DbxSda again.

Ikar

New build of MyDAC version 5.10.0.10 is available for download now.
This version includes:

A runtime package for the TMySQLMonitor component added
Fixed bug with PSGetDefaultOrder method freezing for queries with complicated ORDER BY clauses
Fixed bug in TCRBatchMove with mapping fields by name when Fields count and FieldDefs count are not equal
Fixed bug with adding fields in TVirtualTable
Fixed bug with Pooling and Local Failover
Fixed bug with "Invalid Variant Type" exception under Windows 2000 when TDataSet.Refresh is called
Fixed bug with performance penalty when processing lookup and calculated fields
Problem with DBMonitor integration under Windows Vista Ultimate fixed
Bug with field names quotation in CRDBGrid fixed
Fixed bug with updating FieldDefs for some kind of composite queries
Fixed bug with editing datasets returned by TMyStoredProc
Fixed bug in TMyStoredProc with Local Failover and Disconnected Model
Fixed bug with updating server calculated fields in datasets
Fixed bug with performance loss when editing records containing BLOB and MEMO fields
Fixed bug in the Lock demo

Core Lab development team
http://www.crlab.com/mydac

Devart Forums

Search found 1693 matches

Re: Connection policy

New build of MyDAC 5.10.0.10 is available!