Raised This Month: $ Target: $400
 0% 

Two Questions: 1) dbi-related 2) pragma dynamic


Post New Thread Reply   
 
Thread Tools Display Modes
Author Message
Mugwump
Senior Member
Join Date: May 2004
Old 09-06-2004 , 12:52   Two Questions: 1) dbi-related 2) pragma dynamic
Reply With Quote #1

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 localhost307 ?

(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
Mugwump is offline
BAILOPAN
Join Date: Jan 2004
Old 09-06-2004 , 14:12  
Reply With Quote #2

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.
__________________
egg
BAILOPAN is offline
Mugwump
Senior Member
Join Date: May 2004
Old 09-06-2004 , 14:57  
Reply With Quote #3

Thank you Bailopan, will give both a try.

-Mug
Mugwump is offline
Mugwump
Senior Member
Join Date: May 2004
Old 09-08-2004 , 15:59  
Reply With Quote #4

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.1307' (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
Mugwump is offline
BAILOPAN
Join Date: Jan 2004
Old 09-08-2004 , 16:44  
Reply With Quote #5

I will fix this in TP5, thanks for the report ;]
__________________
egg
BAILOPAN is offline
Reply



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 17:14.


Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Theme made by Freecode