Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
MyFirstSQL
Message
From
31/07/2011 20:44:04
 
 
To
31/07/2011 09:56:14
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Database:
MySQL
Miscellaneous
Thread ID:
01519710
Message ID:
01519767
Views:
47
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform