Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
MyFirstSQL
Message
 
 
À
31/07/2011 09:56:14
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Database:
MySQL
Divers
Thread ID:
01519710
Message ID:
01519767
Vues:
48
>Hi Christian:
>
>I really thank you very much. Althought I had to work all the morning till now I got it. Now with your new explanation I have for experiencing quite more.
>
>I could create a cursor from a database's table. The problem I see is text fields in table convert to memo fields in cursor. That's not a problem if all data in remote table is text but if remote table allows memo fields I don't know how detect such real kind of field.
>
>I tried "TINYTEXT" "TEXT", "CHAR" but no way. Any suggestion?
>
>Thank you again.
>
> Héctor

I use MEDIUMTEXT for memo fields.

Also, in the mysql.ini file you have to add those lines (restart the service after modifying the file):
# Large log files because we use a lot of large fields.
innodb_log_file_size=128M
innodb_log_buffer_size = 8M
innodb_autoextend_increment = 8M
innodb_flush_log_at_trx_commit = 1
After you changed this, you need to stop the mysql service, then delete the log files (ib_logfile0 and ib_logfile1), and then start the mysql service. This will rebuild the logfiles so the startup will take a few seconds longer.

Also, add this line so you can have sufficient connections:
max_connections = 200
And, last but not least, add this line:
# To avoid slow connection because of a reverse DNS lookup:
skip-name-resolve
Christian Isberner
Software Consultant
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform