Recent content by ingresman

You could run some pages (from a browser or wget wtc) and count the number of bytes in the response page. Start with 1 row in the response and then try 2 rows. The difference in page sizes between one row page and two row page will show you how much extra is needed for 1 row. You should be able...

And it's not a PHP issue, you need to try a Microsoft forum (unless Chris's sugestion fixed it)

$5,000 per month sounds like a lot of money. Have you considered hosting in the cloud?. I'm into the Amazon offering at the momemt. They run MySQL instances (which they fully manage) and Oracle as well. Check out http://aws.amazon.com/amis/Sun-Microsystems?browse=1 which lists some Solaris...

The MS$ class should work on Linux as it's all writen in PHP and creates the XML format rather than the older binary format

Excel is used for some interesting things these days not just simple spreadsheets. Have a look at http://phpexcel.codeplex.com/ which might be of interest.

I havn't got mysql on my local machine but I think when you start the terminal monitor it tells you the version, and I think once in the system variables might give a clue

Have you tried switching on ODBC tracing to see what's been sent and recieved rom mysql. Actualy can you give a bit more detail?, for example are you using VFP as a front end to Mysql?. I've never used foxpro so have no idea what's going. The indexthing is funny as you often get issues with the...

No

Or you could read the information_schema to see what is going on and generate dynamic grants from there.

As I say, how would people implement such a solution e.g. scale, connectivity and privacy

I would attack the issue like this: When ever an image needs to be stored create a surrogate key consisting of the logged in user name + the image name e.g. fredJennyonthelawn.jpg Create a hash of this key. Need to stop here, assuming we have 10 web servers the images need to be spread across...

No worries. This is an important issue for dev's and the architecture of any given site I think. For static images like logos yes hold them localy but for images that are uploaded for shoping carts, photo sites etc, the issues of durability, scale, accessability and caching need addressing...

I did say caching might be an issue, When I send images I give it an expirary date well into the future so it never goes back to the server, If I change the image I change it's name so a fresh copy is sent. PC will eventualy delete the unused image. Check out yahoo dev tips on this technique.

Some good points Steve, security and image tampering is an issue. M$ share point holds everything in SQLServer (or even access) but that includes word docs and spreadsheets, they argue that physical security is better with with DB's and they have an incremental backup solution to keep dumps...

I disagre with Phil (ad I always do when this question comes up). I think storing images in the file system stops the site from scaling as without some extra logic or software you are limited to one server. What I would recomend these days is to look as the Amazon S3 service to store images...