Subject Re: complex indexes vs index key fields From Mervyn Bick <invalid@invalid.invalid> Date Tue, 28 Jul 2020 14:14:25 +0200 Newsgroups dbase.getting-started On 2020-07-28 13:59, Akshat Kapoor wrote: > On 28.07.2020 17:02, Gaetano De Luisi wrote: > In this matter we are 2 sides of a coin. I have never used BDE to access > mysql > > For using ADO I would recommend building a test file on the following > pattern > > adodb = new adodatabase() > adodb.connectionstring = "Driver={MySQL ODBC 3.51 > Driver};Server=localhost;Database=muneem;UID=root;PWD=;Port=3306;option=71303680" This should work without problems.  The other options should not be necessary. ..... > You would be required to change other info like the database name, > userid etc. to suit your needs. > > If it runs without error then you can use the executesql method of adodb > object to execute sql. These sql can be for anything insert update or > delete. > > Once you have  working connection then you can use a single query to > insert multiple lines that would run faster than inserting 1 row per query. MySql can apparently handle up to 1000 rows in a single INSERT. I've attached a little program to another message in this thread which may be of use.  The program takes less than a second to create the 8 INSERT statements needed to upload 7577 records.  It will be interesting to see how fast they can be executed. Mervyn.