[PHP-DB] Re: Optimize Tables

2004-05-07 Thread Kim Steinhaug
Another question... Why is it that you feel you need to optimize this? There really isnt any need as far as I can see. The overhead is really small, and will probably go up and down by itself since you have people adding and deleting from the table all the time. If we were talking many MB I could

RE: [PHP-DB] merging a table from multiple servers

2004-05-07 Thread Gary Every
You could do this: Build a sql statement, then connect to each of the servers and save the results in a variable, $result_1 $result_2 Then do: $result_all = array_merge($result_1,$result_2,...) The result sets have to have identical layouts, though. Gary Every Sr. UNIX Administrator Ing

Re: [PHP-DB] merging a table from multiple servers

2004-05-07 Thread Seth Bembeneck
Thanks, I'll try that. Seth "Gary Every" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] You could do this: Build a sql statement, then connect to each of the servers and save the results in a variable, $result_1 $result_2 Then do: $result_all = array_merge($result_1,$result_2,...

[PHP-DB] Re: merging a table from multiple servers

2004-05-07 Thread Kim Steinhaug
I would imagine the best way would be a system that triggers a script on the different serveres. This script creates a datafile which you import with fopen and then you create the database set you need to generate nice stats from. Else you would need the different servers to accept incoming connec

[PHP-DB] From MySQL to PostgreSQL

2004-05-07 Thread Marcjon Louwersheimer
Hi. I developed a forum using php5 and mysql. Right now I'm hosting it on my computer, for version for myself and another for a school I volunteer at. I would like to move the forums to the school's server. Apperently they don't have MySQL, they have PostgreSQL. I was just wondering, how much like