Two Questions: 1) dbi-related 2) pragma dynamic
Hey!
1. Is there a way to specify a port for the dbi's connect routine? For example if I wanted to run a Mysql server off of the standard 3306 port could I specify the hostname to be localhost:port ? eg localhost:3307 ? (if this was asked and answered already pls point me it) 2. I recently saw some discussion recommending larger memory settings using pragma dynamic, I currently use 32768 but my script is nearing 15k lines of code and has hundreds of variables, many of which are large multi-dimensional arrays. In the same thread I saw BAIL recommend a setting of 131072 and someone else post that they observed anything above 32768 causing problems... So I am wondering if I wont run into issues if I double my current memory to 65536 ? Your advice is appreciated! -Mug |
You should be able tospecify a new port in the connection string as the host.
pragma dynamic should be used if you're sure you're getting out of memory errors, but 65536 should be fine. |
Thank you Bailopan, will give both a try.
-Mug |
Bail, apparently specifying a port in the dbi_connect host doesn't work afterall, I get this error:
[MySQL] DB Connection failed(2005): Unknown MySQL Server Host '127.0.0.1:3307' (1) I have tried in addition using localhost and the actual domain of the site but all result in the same error, and I have verified that my Mysql server is running on port 3307 ... -Mug |
I will fix this in TP5, thanks for the report ;]
|
| All times are GMT -4. The time now is 17:14. |
Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.