ABCD OPAC

[alberto Rosenberg]

Helpful

Up

0

Down

Not Helpful

::

Hi, I am migrating the catalog from IAH to ABCD OPAC; the database uses the CEPAL structure and contains approximately 350,000 records. When I run a query, the response takes a long time—over two minutes—and sometimes results in a PHP error or a blank page. I thought the issue might be related to facets, so I removed them, but the problem persists. However, searching within the ABCD Central Module works fine.

Best regards,
Alberto

Topic

[ABCD Community]

Helpful

Up

0

Down

Not Helpful

::

Hi, Alberto!
Could you paste the error messages from the log so we can try to figure out what’s going on? This type of error isn’t common, since we already have CEPAL databases in ABCD that run without performance issues, regardless of their size.

[alberto Rosenberg]

Helpful

Up

0

Down

Not Helpful

::

Hi, for example I get this error:

Fatal error: Maximum execution time of 120 seconds exceeded in C:\xampp\htdocs\central\common\wxis_llamar.php on line 80

PC: AMD A8 Pro-7600B R7, 10 Compute Cores 4c+6g 3.10Ghz. 8 GB Ram. Windows 10
I usually get this error; I could add more time, but the same search in the Central Module works fine.

Thanks
Alberto

[ABCD Community]

Helpful

Up

0

Down

Not Helpful

::

Hi, Alberto!

Line 80 of wxis_llamar.php is as follows:

$result=@file_get_contents($wxisUrl,false, $context);

In this case, the problem may lie with $wxisUrl. Note that this variable is declared in config.php

Originally, it looks like this:


if ($postMethod == '1') {
$wxisUrl = $server_url . "/cgi-bin_Windows/";
if ($unicode != "") $wxisUrl .= "$unicode/";
if ($cisis_ver != "") $wxisUrl .= $cisis_ver . "/";
$wxisUrl .= $wxis_exec; // POST method used
$Wxis = "";
} else {
$wxisUrl = "";
$Wxis = $cgibin_path;
if ($unicode != "") $Wxis .= "$unicode/";
if ($cisis_ver != "") $Wxis .= $cisis_ver . "/";
$Wxis .= $wxis_exec; //GET method is used
}


$server_url constructs the URL: https://your-site/cgi-bin/wxis

My tip:
Test: https://your-site/cgi-bin/wxis?hello

And see if you get a successful result or an error.

There’s likely an error in the cgi-bin configuration, the SSL certificate, or file permissions.

 

[alberto Rosenberg]

Helpful

Up

0

Down

Not Helpful

::

Hello, when I run the command:
(I’m running it in a local test environment)
http://127.0.0.1:9090/cgi-bin/wxis.exe?hello

The response is:
CISIS Interface v5.2bb/PC32/W/M/32767/16/60/I – XML ​​IsisScript WWWISIS 7.1c
CISIS Interface v5.2bb/.iy0/Z/4GB/GIZ/DEC/ISI/UTL/INVX/B7/FAT/CIP/CGI/MX/W
Copyright (c)BIREME/PAHO 2006. [http://www.bireme.br/products/cisis]
WXIS release date: 20070719

The configuration in config.php is as follows:

if ($postMethod == ‘1’){
$wxisUrl=$server_url.”/cgi-bin/”;
if ($unicode!=””) $wxisUrl.=”$unicode/”;
if ($cisis_ver!=””) $wxisUrl.=$cisis_ver.”/”;
$wxisUrl.=$wxis_exec; // POST method used
$Wxis=””;
}else{
$wxisUrl=””;
$Wxis=$cgibin_path;
if ($unicode!=””) $Wxis.=”$unicode/”;
if ($cisis_ver!=””) $Wxis.=$cisis_ver.”/”;
$Wxis.=$wxis_exec; //GET method is used
}

The Editing module works fine; even the same query returns the correct result, unlike in the OPAC. However, if the search result is small, for example, 800 records, it works fine. The problem arises when the search result is large, for example, 12,000 records.

[ABCD Community]

Helpful

Up

0

Down

Not Helpful

::

Actually, it looks like your configuration is correct.

My suggestion, then, is to increase the memory limit and execution time (as a workaround) in php.ini.

max_execution_time = 300
memory_limit = 512M

 

Replace the buscar_integrada.php file in the htdocs/opac folder and let me know the result.

https://abcd-community.org/download/buscar_integrada-teste-2026-07-17/#

 

I made a small modification for very large databases; let me know if it works.

[alberto Rosenberg]

Helpful

Up

0

Down

Not Helpful

::

Hi Roger, sorry for the delay; I was out of the office. I’m getting the following error, with both the modified file and the original. I get the impression that with the “buscar_integrada-teste-2026-07-17” PHP file, the wait time is shorter—though still long—and the response depends on server usage.

[ABCD Community]

Helpful

Up

0

Down

Not Helpful

::

Hi, Alberto!

I’m looking into ways to make OPAC more flexible. It turns out that the relevance system does indeed use more server memory. I’m working on a way to make this feature optional. That way, we’ll have two options: linear search and relevance-based search.

Work is underway on ABCD 4, but this improvement will be included in the new version. I believe it will improve performance.

[ABCD Community]

Helpful

Up

0

Down

Not Helpful

::

Reported issue: https://github.com/ABCD-DEVCOM/ABCD/issues/697

[Author]

Replies