TunerZ (a project in development)

**technomage** · 27-06-2007, 03:47 PM

For MySQL access I use http://sourceforge.net/projects/directsql

It's a very quick not VCL dependent set of components

**Angelo** · 27-06-2007, 05:57 PM

I've had enough for today.
Tomorrow I have to learn [ Yes, school ].
After that I can continue working on my server.
I think Ill use directsql

Here's a list that needs to be done ASAP:

- Stable threads (threads are being free'd too soon)
- MSSQL should be MySQL (shouldn't be too hard, I know how to work with MySQL in PHP, and in the examples I've seen its almost the same)
- Database Structure (I think I can draw/write this on paper tonight)

**wodzu** · 28-06-2007, 07:48 AM

Hi Angelo and good luck with your application

In some previous posts people said that MySQL is faster than MS SQL. I wonder from where they have such informations since in every comparison which I saw the situation was different. Also even on some MySQL related sites its written that MS SQL is known to be the fastest database. Exception might be in case of GUI. MS SQL 2005 GUI is so damn slow.. in comparison to 2000 :| IMHO I think MS SQL is much more powerful database especially when it comes to the SQL dialect. Transact SQL is something that really makes life easier. However in case of hardware requirements MySQL has upper hand here.

I would recommend you to check internet for databases comparison before you make any steps.

Regards.

**Angelo** · 28-06-2007, 09:12 AM

Hello Wodzu,

I thought the same thing as you have written here.
But if they all say exactly the same thing... Well, I'll take a look on the internet.
What MS SQL component would you suggest to use/try ?

Angelo.

**wodzu** · 28-06-2007, 11:51 AM

Originally Posted by Angelo

Hello Wodzu,

What MS SQL component would you suggest to use/try ?

Angelo.

Hello mate.

I am working every day with ADO components. Never had any problems with them. Also I haven't noticed any significant performance drop between running complex queries on server and through ADO in my applications. This is a really good technology as far as I can tell after writing ~20 apps for my company with their usage.

Regards,

Wodzu

**Angelo** · 28-06-2007, 01:39 PM

I am currently using the same system as you describe here.
With ADO components that come along with Delphi.
Currently I'm satisfied with the results of ADO, but it might get slow if the server will execute 1.000 queries at the same moment.

What are the limits (in your experience or found on the internet) of ADO?

Thanks in advance,

Angelo.

**wodzu** · 28-06-2007, 02:32 PM

Originally Posted by Angelo

What are the limits (in your experience or found on the internet) of ADO?

I haven't found any but I wasn't working on the case you refer to. I would suggest you to do some stress tests and see how ADO will behave. Also, I've found a lot articles over the net about ADO and its performance. For example:

http://msdn2.microsoft.com/en-us/library/aa496013(SQL.80).aspx

Quite old but still valuable