View Single Post
  #30  
Old 10-05-2006, 03:38 PM
 
smrtsu smrtsu is offline
 

Advanced Member
  
Join Date: Sep 2004
Posts: 34
 

Default Re: Database Auto-Optimizer

Quote:
Originally Posted by mltriebe
So how can I tell if this is working? I am trying it on my local test copy and can't see any difference in the SQL coding. I have no idea if it is doing anything or not. I know I had some settings wrong in the first few tries but I think I have it all correct now but nothing still seems to be happening.

Thanks

Same here. when I put this "http://localhost/inspa/db_optimizer.php" in the browser i just get a blank page - I have a test site on my localhost, so this is how I have the db_optomizer.php set up:
-----------------------------------------------
# Ensure the script execution request is by the server.
if (empty($_SERVER['REMOTE_ADDR']) && empty($_SERVER['SERVER_ADDR'])) {

# Define Constants
define('ERROR_LOG', 'http://localhost/inspa/log/db_optimization_errors.html');
define('DB_LINK', mysql_connect('localhost','',''));
define('DB_NAME', 'inspa');
----------------------------------------------
also, do I need to create this file? db_optimization_errors.html or does the optimizer do it for you? I don't want to run it on my live site until I make sure I'm doing it correctly.
What am I doing wrong?
__________________
smrtsu
xcart v4.0.17 http://www.ettasays.com
xcart v4.0.19 http://www.inspa.com
Reply With Quote