[PHP-DB] Re: SQL or array ?

2005-04-23 Thread Frank M Flynn
Paul, Interesting - I don't know which would give better performance, there are too many things I don't know about your set up but here are some general rules I think would apply: How many files are we talking about? If it's many I think a database is the only way to go. What happens when you

Re: [PHP-DB] SQL or array ?

2005-04-23 Thread M Saleh EG
Only? That aint too big, but now i'm confused what's ur hardware and O.Sspecs? 300 to 500 would be a peice of cake to load. However, it depends on ur system. I would rather use the array than hitting the db for the query. Because the bottom line is that you will receive your data in an array no m

[PHP-DB] postgresql and php

2005-04-23 Thread Tate
I have php and postgresql installed on my laptop with linux fedora core 3. Everything is working fine, but I have created a survey and want the entries automatically inserted into the database. I know what my SQL should be, but I'm not sure if my other coding is correct. In my form, I have ra

Re: [PHP-DB] SQL or array ?

2005-04-23 Thread Paul Reilly
> explain the phrase "big array." I guess everything is relative! We're talking about 300-500 items here. Paul -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] SQL or array ?

2005-04-23 Thread Mark Cain
explain the phrase "big array." What is big to you might not be big to the server nor to me but then again maybe it's bigger. Are you talking dozens, hundreds, thousands, millions?? - Original Message - From: "Paul Reilly" <[EMAIL PROTECTED]> To: Sent: Saturday, April 23, 2005 5:05 PM S

[PHP-DB] SQL or array ?

2005-04-23 Thread Paul Reilly
I have a quick question about which would the best way to implement something in terms of performance. Using a database, or just creating a big array in memory? I have a PHP file manager script which creates an array of all files in a directory, and get's their mime types. It then prints these fi

[PHP-DB] help wanted for install php with mysql support on windows

2005-04-23 Thread zheng
I use Apache1.3,php5.0(they work fine) and mysql 4.1(it also can work separately) . But when I interact with MySql using php,it says " Fatal error: Call to undefined function mysql_connect() ", I have uncommented php_mysql.dll inside php.ini and add D:\php to the system variable path, the libmy