Aaron
Posts: 145
|
Posted: 03/04/2004, 7:52 AM |
|
I am trying to query a mySQL db with multiple tables. 2 tables I'm trying to pull partial information from are joined a common row. Right now, as it's written, the server takes almost 2 minutes to display the page. This is just the inital load of the page, no actual searches have been performed yet. This server is a P4 with 1GB ram.
Any help would be appreciated.
Aaron
--------Code-------
function Open()
{
$this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeBuildSelect");
$this->CountSQL = "SELECT COUNT(*) " .
"FROM address INNER JOIN individual ON " .
"address.entityID = individual.entityID";
$this->SQL = "SELECT street1, street2, street3, city, state, zip, fullName, address.addressID " .
"FROM address INNER JOIN individual ON " .
"address.entityID = individual.entityID";
$this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeExecuteSelect");
$this->RecordsCount = CCGetDBValue(CCBuildSQL($this->CountSQL, $this->Where, ""), $this);
$this->query(CCBuildSQL($this->SQL, $this->Where, $this->Order));
$this->CCSEventResult = CCGetEvent($this->CCSEvents, "AfterExecuteSelect");
$this->MoveToPage($this->AbsolutePage);
}
|
|
|
Nicole
Posts: 586
|
Posted: 03/09/2004, 6:12 AM |
|
Aaron,
Please re-post your question to CCS PHP forum http://forums.codecharge.com/forum.php?forum_id=5
As this is CC discussion lets don't make a mess
_________________
Regards,
Nicole |
|
|
Aaron
Posts: 145
|
Posted: 03/10/2004, 5:06 AM |
|
Sorry 'bout that. I've actually figured it out; so if there is any way to just delete this topic...
|
|
|
|