Search found 14 matches

by CFaiga
Fri 12 Mar 2010 09:38
Forum: MySQL Data Access Components
Topic: How do I get the duration the SQL statement to run
Replies: 1
Views: 1606

How do I get the duration the SQL statement to run

Hi

I am using MySQLMonitorSQL to log my sql commands.
How do I get the duration in milliseconds that the SQL took to run.

Thanks

Code: Select all

procedure TFrmMain.MySQLMonitorSQL(Sender: TObject; Text: string;Flag: TDATraceFlag); 
var 
  Duration : Integer; // how long the query takes
begin    
   Duration := ??; // how do I get this value ?
   LogSqlStament(Duration,Text)

end;

by CFaiga
Sat 17 Jan 2009 08:34
Forum: MySQL Data Access Components
Topic: Coverting a TMyQuery dataset to TClientDataSet in Delphi
Replies: 3
Views: 2742

Please can you show me some sample code
by CFaiga
Wed 14 Jan 2009 16:37
Forum: MySQL Data Access Components
Topic: Coverting a TMyQuery dataset to TClientDataSet in Delphi
Replies: 3
Views: 2742

Coverting a TMyQuery dataset to TClientDataSet in Delphi

Hi I make use of the Mydac components by devart (corelab) to access MySql from Delphi (2006) Very often I need to work with data in a TClientDataSet What is the best way to convert the dataset of a TMyQuery to TClientDataSet
by CFaiga
Fri 04 Apr 2008 14:05
Forum: Universal Data Access Components
Topic: Is UniDac thread safe - ?
Replies: 2
Views: 5755

Thanks a great pity

The unidac set of components look very nice but I can not use them in a large Midas/Data Snap Application there will be to many connections to the database
by CFaiga
Sun 30 Mar 2008 20:29
Forum: Universal Data Access Components
Topic: Is UniDac thread safe - ?
Replies: 2
Views: 5755

Is UniDac thread safe - ?

Mydac version 5 is it not thread safe and one TMyConnection connection is need per thread in a Midas Application

Does UniDac have the same problem ?
by CFaiga
Wed 05 Dec 2007 11:13
Forum: MySQL Data Access Components
Topic: Is version 5 of MyDac thread-safe ?
Replies: 3
Views: 2346

Are there any plans to fix this in version 6
by CFaiga
Tue 04 Dec 2007 21:24
Forum: MySQL Data Access Components
Topic: Is version 5 of MyDac thread-safe ?
Replies: 3
Views: 2346

Is version 5 of MyDac thread-safe ?

My System is using Mydac version 4 with Midas and a has a TMyConnection per thread
Antaeus wrote:> As the MyDac isn't thread-safe ...
MyDAC can work in multithreaded applications, so it is thread safe. But the restriction is that you cannot use one component for more than one thread simultaneously.
> are rthey compatible with Midas ?
Yes, MyDAC is compatible with Midas. Please see Midas demo for example.
> what must be done to make them thread safe ?
In your case using one instanse of TMyConnection per thread must be helpful.

Does version 5 have the same problem ?

using one connection per thread my applation can use up to 16 connections per user - and that is a problem

Do you have any ideas on how I can share 1 connection to many RDMs in a Midas application ?
by CFaiga
Thu 05 Apr 2007 14:15
Forum: MySQL Data Access Components
Topic: ReceiveHeader : Net packets out of order : received[0], expexted[1]
Replies: 30
Views: 40927

Using MIDAS with MyDac

Antaeus wrote:> As the MyDac isn't thread-safe ...
MyDAC can work in multithreaded applications, so it is thread safe. But the restriction is that you cannot use one component for more than one thread simultaneously.

With this limitation

> you can only use one component per thread simultaneously.

In my MIDAS App I have more than one TRemoteDataModule (RDM)
Does this mean I need a Connection for each RDM ?
by CFaiga
Wed 28 Jun 2006 16:09
Forum: MySQL Data Access Components
Topic: MyDac or MySql error ??
Replies: 1
Views: 2007

MyDac or MySql error ??

Hi

I am run MySql Version 5.0.21 and MyDac under Delphi 7 using
Midas


some times when calling a Stored Procedure I get this error

Code:2014 -- Commands out of sync; You can't run this command now
Code:1156 -- ReceiveHeader: Net packets out of order: received[5], expected[1]]

any Ideas on how to fix this ?

Charles
by CFaiga
Sat 24 Jun 2006 09:10
Forum: MySQL Data Access Components
Topic: transactions - with midas and mydac
Replies: 1
Views: 1858

transactions - with midas and mydac

Hi

How does one do transacations with mydac, mysql and midas
while calling an number of Stored procedures


I am using
-Delphi 7 with
- MySql ver5.0.21,
- Midas and
- Mydac


thanks
by CFaiga
Wed 19 Apr 2006 00:05
Forum: MySQL Data Access Components
Topic: ReceiveHeader : Net packets out of order : received[0], expexted[1]
Replies: 30
Views: 40927

If you work with threads, you should use a connection for each thread. MyDac isn't thread-safe, this is probably what induces your problem.

Part of my system is running under Midas

I only have one connection to the database


As the MyDac isn't thread-safe are rthey compatable with Midas ?
what must be done to make them thread safe ?
by CFaiga
Sun 12 Feb 2006 20:11
Forum: MySQL Data Access Components
Topic: ReceiveHeader : Net packets out of order : received[0], expexted[1]
Replies: 30
Views: 40927

This problem happens when the system is very busy
most of my database access is done via stored proceudres

The problem happens when more than one stored proceudre is accessing the database at the same time
by CFaiga
Sun 12 Feb 2006 11:54
Forum: MySQL Data Access Components
Topic: ssleay32.dll and libeay32.dll files
Replies: 1
Views: 2540

ssleay32.dll and libeay32.dll files

were do i find these files ?


Sets properties required for protected SSL connection with the server. These properties can be used only for Options.Protocol = mpSSL

For using ssleay32.dll and libeay32.dll files are needed.
by CFaiga
Sun 12 Feb 2006 09:44
Forum: MySQL Data Access Components
Topic: ReceiveHeader : Net packets out of order : received[0], expexted[1]
Replies: 30
Views: 40927

ReceiveHeader : Net packets out of order : received[0], expexted[1]

some times I get the error message
ReceiveHeader : Net packets out of order : received[0], expexted[1]
My software then stops working

any ideas ?


- Exact version of Delphi : Delphi 7.0 (Build 8.1) Enterprise
- Exact version of MyDAC430d7.exe
- Exact version of MySQL version 5.0.18-win32