Professional Web Applications Themes

#39684 [NEW]: send data from mysql to php takes long time - PHP Bugs

From: v at sas dot nsk dot su Operating system: OpenBSD PHP version: 5.2.0 PHP Bug Type: MySQL related Bug description: send data from mysql to php takes long time Description: ------------ Hello! I have problem: I have IPB forum installed. After search in IPB (search takes about 3-4 seconds for post table about 300 000 records) mysql shows "Sending Data" status and takes about 3-5 minutes. I tested with PHP 5.2, PHP 4.4, PHP 4.2.3 - with same results. I switched from MySQL 4.2.18 to 4.2.21 and 4.2.22 with same result. I tested with apache module, fastCGI with NGINX ...

  1. #1

    Default #39684 [NEW]: send data from mysql to php takes long time

    From: v at sas dot nsk dot su
    Operating system: OpenBSD
    PHP version: 5.2.0
    PHP Bug Type: MySQL related
    Bug description: send data from mysql to php takes long time

    Description:
    ------------
    Hello!
    I have problem:
    I have IPB forum installed. After search in IPB (search takes about 3-4
    seconds for post table about 300 000 records) mysql shows "Sending Data"
    status and takes about 3-5 minutes.

    I tested with PHP 5.2, PHP 4.4, PHP 4.2.3 - with same results.
    I switched from MySQL 4.2.18 to 4.2.21 and 4.2.22 with same result.

    I tested with apache module, fastCGI with NGINX web server - same results.


    I tested mysql connections with socket and network connection.

    May be I missed some variables from php.ini?
    Main question - how I can speedup code for accept "Sending data" stage
    between PHP and MySQL more fast?



    --
    Edit bug report at [url]http://bugs.php.net/?id=39684&edit=1[/url]
    --
    Try a CVS snapshot (PHP 4.4): [url]http://bugs.php.net/fix.php?id=39684&r=trysnapshot44[/url]
    Try a CVS snapshot (PHP 5.2): [url]http://bugs.php.net/fix.php?id=39684&r=trysnapshot52[/url]
    Try a CVS snapshot (PHP 6.0): [url]http://bugs.php.net/fix.php?id=39684&r=trysnapshot60[/url]
    Fixed in CVS: [url]http://bugs.php.net/fix.php?id=39684&r=fixedcvs[/url]
    Fixed in release: [url]http://bugs.php.net/fix.php?id=39684&r=alreadyfixed[/url]
    Need backtrace: [url]http://bugs.php.net/fix.php?id=39684&r=needtrace[/url]
    Need Reproduce Script: [url]http://bugs.php.net/fix.php?id=39684&r=needscript[/url]
    Try newer version: [url]http://bugs.php.net/fix.php?id=39684&r=oldversion[/url]
    Not developer issue: [url]http://bugs.php.net/fix.php?id=39684&r=support[/url]
    Expected behavior: [url]http://bugs.php.net/fix.php?id=39684&r=notwrong[/url]
    Not enough info: [url]http://bugs.php.net/fix.php?id=39684&r=notenoughinfo[/url]
    Submitted twice: [url]http://bugs.php.net/fix.php?id=39684&r=submittedtwice[/url]
    register_globals: [url]http://bugs.php.net/fix.php?id=39684&r=globals[/url]
    PHP 3 support discontinued: [url]http://bugs.php.net/fix.php?id=39684&r=php3[/url]
    Daylight Savings: [url]http://bugs.php.net/fix.php?id=39684&r=dst[/url]
    IIS Stability: [url]http://bugs.php.net/fix.php?id=39684&r=isapi[/url]
    Install GNU Sed: [url]http://bugs.php.net/fix.php?id=39684&r=gnused[/url]
    Floating point limitations: [url]http://bugs.php.net/fix.php?id=39684&r=float[/url]
    No Zend Extensions: [url]http://bugs.php.net/fix.php?id=39684&r=nozend[/url]
    MySQL Configuration Error: [url]http://bugs.php.net/fix.php?id=39684&r=mysqlcfg[/url]
    v at sas dot nsk dot su Guest

  2. #2

    Default #39684 [Opn->Bgs]: send data from mysql to php takes long time

    ID: 39684
    Updated by: [email]tony2001php.net[/email]
    Reported By: v at sas dot nsk dot su
    -Status: Open
    +Status: Bogus
    Bug Type: MySQL related
    Operating System: OpenBSD
    PHP Version: 5.2.0
    New Comment:

    Sorry, but your problem does not imply a bug in PHP itself. For a
    list of more appropriate places to ask for help using PHP, please
    visit [url]http://www.php.net/support.php[/url] as this bug system is not the
    appropriate forum for asking support questions. Due to the volume
    of reports we can not explain in detail here why your report is not
    a bug. The support channels will be able to provide an explanation
    for you.

    Thank you for your interest in PHP.




    Previous Comments:
    ------------------------------------------------------------------------

    [2006-11-29 14:44:28] v at sas dot nsk dot su

    Description:
    ------------
    Hello!
    I have problem:
    I have IPB forum installed. After search in IPB (search takes about 3-4
    seconds for post table about 300 000 records) mysql shows "Sending Data"
    status and takes about 3-5 minutes.

    I tested with PHP 5.2, PHP 4.4, PHP 4.2.3 - with same results.
    I switched from MySQL 4.2.18 to 4.2.21 and 4.2.22 with same result.

    I tested with apache module, fastCGI with NGINX web server - same
    results.

    I tested mysql connections with socket and network connection.

    May be I missed some variables from php.ini?
    Main question - how I can speedup code for accept "Sending data" stage
    between PHP and MySQL more fast?




    ------------------------------------------------------------------------


    --
    Edit this bug report at [url]http://bugs.php.net/?id=39684&edit=1[/url]
    tony2001@php.net Guest

Similar Threads

  1. Send and receive data from mysql.
    By onelotusguy in forum Macromedia Flash Data Integration
    Replies: 6
    Last Post: July 2nd, 11:51 PM
  2. Illustrator takes a long time to become active when switching between programs
    By jonathan_himmel@adobeforums.com in forum Adobe Illustrator Macintosh
    Replies: 7
    Last Post: April 23rd, 10:49 PM
  3. File Takes an Unexpectedly Long Time to Open Through SMB Protocol
    By Heber Soto in forum Windows Networking
    Replies: 1
    Last Post: July 16th, 09:33 PM
  4. Replies: 1
    Last Post: July 15th, 10:20 PM
  5. View Workgroup Computers takes a long time
    By Joe Dolsak in forum Windows XP/2000/ME
    Replies: 1
    Last Post: July 3rd, 07:35 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139