Recent content by Tama

Hi there We're in the process of migrating our Oracle based Library Management System to a newer version which supports Unicode characters. Almost all of our reporting is done through Crystal Reports 10 connecting via ODBC. We have the system running in a test environment and although I...

Thank you Sleipnir - your post made me step back and have a think about how to do this in a way that doesn't suck. I think I've worked out a way to transmit minimal data via GET, use bugger all CPU, and make one MySQL connection per page. Will let you know how I go. Tama I do my sums on...

Damn, I realized my mistake about two seconds after posting the code. Whoops, sorry. [blush] I've found what (I think) I'm after - urldecode/ urlencode. I can't believe I missed these before. In the long run I need to look at a more efficient way of doing this. Cheers Tama I do my sums on...

What I'm trying to do is generate banners (which rotate) and put them in IFRAMEs (so people on slow connections have their content load first.) The first thing I tried to do was run the IFRAME as a seperate piece of PHP code with a MySQL connection but that rapidly overloaded the DB and CPU as...

Hey there I'm wanting to send small segments of HTML to other webpages (in my case IFRAMEs.) Along these lines: http://www.mysite.com/newpage.php?content=HTMLHERE I've been using base64_encode / base64_decode but guessing that this is CPU intensive. Is there any other ways I can encode/decode...

I've been trying to install xdebug from http://www.xdebug.org but have run into problems with Zend Optimizer. Derick who developed xdebug has been a great help but I just can't seem to disable the Zend Optimizer which is frustrating. It's bed time at my end of the world so I'll sleep on it...

Thank donkeyhote I must have screwed up somehow first time around and made a typo. I repeated steps 3 to 5 again and it worked a charm. If there was an embarrassed smilie to use I put it here => Tama I do my sums on fingers and thumbs.

Hi there I am in the process of installing the xdebug module on my Linux server. Unfortunately I'm am very un-experienced with the "make" command (and Linux in general) and having followed the following steps without any problems:1. Unpack the tarball: tar -xzf xdebug-1.x.x.tgz. Note that you...

OK - I must admit I started down this path (but with different search terms - "php profiler" works a lot better thank you.) There seemed to be a huge amount of options available and I wasn't sure which one I should invest time into as most of them seemed fairly complex. I'm running Apache...

I'm running a very complex/ mutilated version of PHPNuke/phpBB and have been running into performance issues with my server. After going through the long process of identifying the problem it seems to be resting in the PHP code (not MySQL as originally thought.) There seems to be some code...

Cool - I know just the table to test it on - will give it a shot over the next few days and get back to you. Cheers Tama I do my sums on fingers and thumbs.

Hi Bastien Sorry for the delay in replying, network problems drove me to take a break from work, which was all good. I haven't made the format conversion you mention. Does InnoDB require BEGIN/COMMIT to function properly? I had assumed that BEGIN/COMMIT was only needed with multiple queries in...

Hi there I've recently got all inspired and purchased "High Performance SQL" - an O'Reilly's book. Using a slow query log I'd already identified two tables that were causing problems. Both had an equal number of SELECT and UPDATE/DELETE statements being run against them. This was leading to...

Oh crap - since moving 3 of my high use MyISAM tables to Inno DB page generation has gone through the roof! Queries using the Inno DB tables are showing pathetically slow times on my slow query log. ARGH! No, I'm not panicking - well, perhaps a wee bit... ...any ideas? Anyone? Tama I do my...

The tables at MyISAM, but there seems to be an option to change tables to INNO DB. I've just had a read of: http://dev.mysql.com/doc/mysql/en/Converting_tables_to_InnoDB.html and it seems like a worthwhile change to investigate. Does anyone have experience with changing MyISAM to Inno DB and...