Zobrazit v EDS

Benchmarking PHP–MySQL Communication: A Comparative Study of MySQLi and PDO Under Varying Query Complexity.

Uloženo v:
Podrobná bibliografie
Název: Benchmarking PHP–MySQL Communication: A Comparative Study of MySQLi and PDO Under Varying Query Complexity.
Autoři: Andrijević, Nebojša, Lovreković, Zoran, Salkić, Hadžib, Šarčević, Đorđe, Perišić, Jasmina
Zdroj: Electronics (2079-9292); Jan2026, Vol. 15 Issue 1, p21, 51p
Témata: PHP (Computer program language), BENCHMARKING (Management), CLIENT/SERVER computing, RELATIONAL databases, COMPUTATIONAL complexity
Abstrakt: Efficient interaction between PHP (Hypertext Preprocessor) applications and MySQL databases is essential for the performance of modern web systems. This study systematically compares the two most widely used PHP APIs for working with MySQL databases—MySQLi (MySQL Improved extension) and PDO (PHP Data Objects)—under identical experimental conditions. The analysis covers execution time, memory consumption, and the stability and variability of results across different types of SQL (Structured Query Language) queries (simple queries, complex JOIN, GROUP BY/HAVING). A specialized benchmarking tool was developed to collect detailed metrics over several hundred repetitions and to enable graphical and statistical evaluation. Across the full benchmark suite, MySQLi exhibits the lowest mean wall-clock execution time on average (≈15% overall). However, under higher query complexity and in certain connection-handling regimes, PDO prepared statement modes provide competitive latency with improved predictability. These results should be interpreted as context-aware rankings for the tested single-host environment and workload design, and as a reusable benchmarking framework intended for replication under alternative deployment models. Statistical analysis (Kruskal–Wallis and Mann–Whitney tests) confirms significant differences between the methods, while Box-plots and histograms visualize deviations and the presence of outliers. Unlike earlier studies, this work provides a controlled and replicable benchmarking environment that tests both MySQLi and PDO across multiple API modes and isolates the impact of native versus emulated prepared statements. It also evaluates performance under complex-query workloads that reflect typical reporting and analytics patterns on the ClassicModels schema. To our knowledge, no previous study has analyzed these factors jointly or provided a reusable tool enabling transparent comparison across PHP–MySQL access layers. The findings provide empirical evidence and practical guidelines for choosing the optimal API depending on the application scenario, as well as a tool that can be applied for further testing in various web environments. [ABSTRACT FROM AUTHOR]
Copyright of Electronics (2079-9292) is the property of MDPI and its content may not be copied or emailed to multiple sites without the copyright holder's express written permission. Additionally, content may not be used with any artificial intelligence tools or machine learning technologies. However, users may print, download, or email articles for individual use. This abstract may be abridged. No warranty is given about the accuracy of the copy. Users should refer to the original published version of the material for the full abstract. (Copyright applies to all Abstracts.)
Databáze: Complementary Index
FullText Text:
  Availability: 0
CustomLinks:
  – Url: https://resolver.ebscohost.com/openurl?sid=EBSCO:edb&genre=article&issn=20799292&ISBN=&volume=15&issue=1&date=20260101&spage=21&pages=21-71&title=Electronics (2079-9292)&atitle=Benchmarking%20PHP%E2%80%93MySQL%20Communication%3A%20A%20Comparative%20Study%20of%20MySQLi%20and%20PDO%20Under%20Varying%20Query%20Complexity.&aulast=Andrijevi%C4%87%2C%20Neboj%C5%A1a&id=DOI:10.3390/electronics15010021
    Name: Full Text Finder
    Category: fullText
    Text: Full Text Finder
    Icon: https://imageserver.ebscohost.com/branding/images/FTF.gif
    MouseOverText: Full Text Finder
  – Url: https://www.webofscience.com/api/gateway?GWVersion=2&SrcApp=EBSCO&SrcAuth=EBSCO&DestApp=WOS&ServiceName=TransferToWoS&DestLinkType=GeneralSearchSummary&Func=Links&author=Andrijevi%C4%87%20N
    Name: ISI
    Category: fullText
    Text: Nájsť tento článok vo Web of Science
    Icon: https://imagesrvr.epnet.com/ls/20docs.gif
    MouseOverText: Nájsť tento článok vo Web of Science
Header DbId: edb
DbLabel: Complementary Index
An: 190824409
RelevancyScore: 1082
AccessLevel: 6
PubType: Academic Journal
PubTypeId: academicJournal
PreciseRelevancyScore: 1082.40466308594
IllustrationInfo
Items – Name: Title
  Label: Title
  Group: Ti
  Data: Benchmarking PHP–MySQL Communication: A Comparative Study of MySQLi and PDO Under Varying Query Complexity.
– Name: Author
  Label: Authors
  Group: Au
  Data: <searchLink fieldCode="AR" term="%22Andrijević%2C+Nebojša%22">Andrijević, Nebojša</searchLink><br /><searchLink fieldCode="AR" term="%22Lovreković%2C+Zoran%22">Lovreković, Zoran</searchLink><br /><searchLink fieldCode="AR" term="%22Salkić%2C+Hadžib%22">Salkić, Hadžib</searchLink><br /><searchLink fieldCode="AR" term="%22Šarčević%2C+Đorđe%22">Šarčević, Đorđe</searchLink><br /><searchLink fieldCode="AR" term="%22Perišić%2C+Jasmina%22">Perišić, Jasmina</searchLink>
– Name: TitleSource
  Label: Source
  Group: Src
  Data: Electronics (2079-9292); Jan2026, Vol. 15 Issue 1, p21, 51p
– Name: Subject
  Label: Subject Terms
  Group: Su
  Data: <searchLink fieldCode="DE" term="%22PHP+%28Computer+program+language%29%22">PHP (Computer program language)</searchLink><br /><searchLink fieldCode="DE" term="%22BENCHMARKING+%28Management%29%22">BENCHMARKING (Management)</searchLink><br /><searchLink fieldCode="DE" term="%22CLIENT%2FSERVER+computing%22">CLIENT/SERVER computing</searchLink><br /><searchLink fieldCode="DE" term="%22RELATIONAL+databases%22">RELATIONAL databases</searchLink><br /><searchLink fieldCode="DE" term="%22COMPUTATIONAL+complexity%22">COMPUTATIONAL complexity</searchLink>
– Name: Abstract
  Label: Abstract
  Group: Ab
  Data: Efficient interaction between PHP (Hypertext Preprocessor) applications and MySQL databases is essential for the performance of modern web systems. This study systematically compares the two most widely used PHP APIs for working with MySQL databases—MySQLi (MySQL Improved extension) and PDO (PHP Data Objects)—under identical experimental conditions. The analysis covers execution time, memory consumption, and the stability and variability of results across different types of SQL (Structured Query Language) queries (simple queries, complex JOIN, GROUP BY/HAVING). A specialized benchmarking tool was developed to collect detailed metrics over several hundred repetitions and to enable graphical and statistical evaluation. Across the full benchmark suite, MySQLi exhibits the lowest mean wall-clock execution time on average (≈15% overall). However, under higher query complexity and in certain connection-handling regimes, PDO prepared statement modes provide competitive latency with improved predictability. These results should be interpreted as context-aware rankings for the tested single-host environment and workload design, and as a reusable benchmarking framework intended for replication under alternative deployment models. Statistical analysis (Kruskal–Wallis and Mann–Whitney tests) confirms significant differences between the methods, while Box-plots and histograms visualize deviations and the presence of outliers. Unlike earlier studies, this work provides a controlled and replicable benchmarking environment that tests both MySQLi and PDO across multiple API modes and isolates the impact of native versus emulated prepared statements. It also evaluates performance under complex-query workloads that reflect typical reporting and analytics patterns on the ClassicModels schema. To our knowledge, no previous study has analyzed these factors jointly or provided a reusable tool enabling transparent comparison across PHP–MySQL access layers. The findings provide empirical evidence and practical guidelines for choosing the optimal API depending on the application scenario, as well as a tool that can be applied for further testing in various web environments. [ABSTRACT FROM AUTHOR]
– Name: Abstract
  Label:
  Group: Ab
  Data: <i>Copyright of Electronics (2079-9292) is the property of MDPI and its content may not be copied or emailed to multiple sites without the copyright holder's express written permission. Additionally, content may not be used with any artificial intelligence tools or machine learning technologies. However, users may print, download, or email articles for individual use. This abstract may be abridged. No warranty is given about the accuracy of the copy. Users should refer to the original published version of the material for the full abstract.</i> (Copyright applies to all Abstracts.)
PLink https://erproxy.cvtisr.sk/sfx/access?url=https://search.ebscohost.com/login.aspx?direct=true&site=eds-live&db=edb&AN=190824409
RecordInfo BibRecord:
  BibEntity:
    Identifiers:
      – Type: doi
        Value: 10.3390/electronics15010021
    Languages:
      – Code: eng
        Text: English
    PhysicalDescription:
      Pagination:
        PageCount: 51
        StartPage: 21
    Subjects:
      – SubjectFull: PHP (Computer program language)
        Type: general
      – SubjectFull: BENCHMARKING (Management)
        Type: general
      – SubjectFull: CLIENT/SERVER computing
        Type: general
      – SubjectFull: RELATIONAL databases
        Type: general
      – SubjectFull: COMPUTATIONAL complexity
        Type: general
    Titles:
      – TitleFull: Benchmarking PHP–MySQL Communication: A Comparative Study of MySQLi and PDO Under Varying Query Complexity.
        Type: main
  BibRelationships:
    HasContributorRelationships:
      – PersonEntity:
          Name:
            NameFull: Andrijević, Nebojša
      – PersonEntity:
          Name:
            NameFull: Lovreković, Zoran
      – PersonEntity:
          Name:
            NameFull: Salkić, Hadžib
      – PersonEntity:
          Name:
            NameFull: Šarčević, Đorđe
      – PersonEntity:
          Name:
            NameFull: Perišić, Jasmina
    IsPartOfRelationships:
      – BibEntity:
          Dates:
            – D: 01
              M: 01
              Text: Jan2026
              Type: published
              Y: 2026
          Identifiers:
            – Type: issn-print
              Value: 20799292
          Numbering:
            – Type: volume
              Value: 15
            – Type: issue
              Value: 1
          Titles:
            – TitleFull: Electronics (2079-9292)
              Type: main
ResultId 1