Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Unicode Characters Don't Display in CR10
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...- Tama
- Thread
- Replies: 2
- Forum: Business Objects: Crystal Reports 4 Other topics
-
Encoding HTML to transmit via URL
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... -
Encoding HTML to transmit via URL
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... -
Encoding HTML to transmit via URL
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... -
Encoding HTML to transmit via URL
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... -
How do I identify "slow" code?
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... -
Proper Syntax for Make Command
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.- Tama
- Post #3
- Forum: Linux (server)
-
Proper Syntax for Make Command
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...- Tama
- Thread
- Replies: 4
- Forum: Linux (server)
-
How do I identify "slow" code?
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... -
How do I identify "slow" code?
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... -
Changed MyISAM to InnoDB - getting really slow UPDATES
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. -
Changed MyISAM to InnoDB - getting really slow UPDATES
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... -
Changed MyISAM to InnoDB - getting really slow UPDATES
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... -
Tweaking MySQL Variables
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... -
Tweaking MySQL Variables
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... -
Tweaking MySQL Variables
OK - I've been running the slow query log for a while and it's picked up three queries that obviously run into problems: 1. Is part of a search routine that scans 3.5+ million rows so I'm not to bugged by this. 2. Confuses the hell out of me. It's an UPDATE command that updates two MEDINT... -
Tweaking MySQL Variables
You are not mentioning any specific problems so its tough to suggest things... Sorry, I forgot to state my problem. I'm using a chat script and page generation times noticeably rise with users logged on the chat. For example, over 1 hour when an average of 9 people were on Chat the page... -
Tweaking MySQL Variables
Hi there I'm troubleshooting performance problems with my dynamic website that's run off MySQL. The MySQL variables are default and I'm wondering if I should look at changing any of them. My Server: 2.4Ghz Celeron (400FSB) 512meg RAM (DDR) 40gig H/D (7200rpm) Apache 2.0 Fedora MySQL 4.0.20... -
How do I send POST (Form) information without the user hitting Submit?
Hmmm... this might be a bit trickier than that... search-forum.php is my "easy" name of the search function in phpBB which is sitting inside PHPNuke - so there's quite a few layers there. It's 11:30am Monday morning here (New Zealand) so I'll have to wait until I get home before I can fiddle... -
How do I send POST (Form) information without the user hitting Submit?
Ah... I think I just clicked... I could put a case list in search-selector.php that does the required alterations to the POST info from mypage.html - and then include search-forum.php (or whatever) and the POST information would then be picked up from mypage.html (with alterations?) Slap me if...
