X-Cart forums

[NuAlpha]

Originally Posted by adpboss

YES BUT NU ALPHA PLEASE MAKE XCART PHP BETTER. XCART PHP IS SLOW.

Please look at some of my other posts concerning speed tips and modifications for PHP speed. I have posted several.

As I have posted before, I fully recommend you optimize your databases. This can make a noticeable difference.

Use the script I posted to automatically optimize every database table each day (not sure of the title posted under).

Optmize your database by changing the types and sizes of columns. Do this consistantly. If you change one field from varchar(255) to varchar(32) make sure you change every column with the same name in every table to match if possible.

Having smaller and stricter datatypes will improve the lookup speed of your database. For instance, if you truly believe that your thumbnails are going to need 11 digits to describe their dimensions, then leave the products table the way it is. Otherwise I recommend changing them to SMALLINT(5), UNSIGNED.

Be careful with the above. Enter the wrong data type size and MySQL will 'trim the fat' off your column values, so to speak. For instance, if you used TINYINT(3) on those fields you would find yourself in trouble because all values over 127 would be altered to comply.
http://dev.mysql.com/doc/mysql/en/Numeric_types.html

If you modify any field for size, use the following SQL statement to figure out what the max value is using PHPMyAdmin. Fill in the 'field_name' and 'table_name' where appropriate:

SELECT field_name,CHAR_LENGTH(field_name) AS measured_length FROM table_name WHERE CHAR_LENGTH(field_name)>1 ORDER BY measured_length DESC

That should show you what the current max value is. Use your knowledge of that field and what your site requires that field to hold to judge what amount of extra space you should allow. For instance, if your smallest 'alt' field is 52 chars, you might figure that you'll probably not see anything larger than 64 chars.

Important: Perform any changes on a backup version of the database on your local test server!!

One final note: Do the database optimizations at your own risk. If you don't know what your doing you can royally screw things up (see "Important" notation above).

I recommend buying High Performance MySQL if you are interested in learning more about DB optimization. Especially useful if you host off a dedicated server or your own system.

[adpboss]

I read all your optimization posts Nu Alpha. I just haven't had time to integrate very many of them. I have set up an optimize script to run daily and a repair script to run twice weekly.

I will buy that book. I love learning. Almost as much as I like making money.

[NuAlpha]

Originally Posted by markwhoo

NuAlpha, You do as ADP has requested, and ahem, I think we all would agree, I promise to call it NuApha's XCart!

what ya think? Sound great!

Nobody take this the wrong way (especially the Xcart team) but that is inching its way to the truth. I have spent the last 1 year and four months rewriting a good portion of Xcart. I have altered and added many thousands of lines of code thus far. Not saying what and where, but many Xcart owners should get a pretty good picture of what we have been up to in the coming months. As I said in another post...stay tuned.

[markwhoo]

Originally Posted by NuAlpha

Nobody take this the wrong way (especially the Xcart team) but that is inching its way to the truth. I have spent the last 1 year and four months rewriting about a fourth of Xcart. Over 10,000 lines of code thus far. Not saying what and where, but many Xcart owners should get a pretty good picture of what we have been up to in the coming months. As I said in another post...stay tuned.

ROFL,

You mean "Turbo Cart?"

I'm ready for it!

Add me to your email list for sure!

[NuAlpha]

Originally Posted by markwhoo

ROFL,

You mean "Turbo Cart?"

I'm ready for it!

Add me to your email list for sure!

Hope your not expecting a replacement.

I like Xcart, but I'd like it more if it did everything I wanted. I am just glad the code is modifiable. Good thing this isn't MS Xcart, otherwise there'd be no hope.

[markwhoo]

Originally Posted by NuAlpha

Hope your not expecting a replacement.

I like Xcart, but I'd like it more if it did everything I wanted. I am just glad the code is modifiable. Good thing this isn't MS Xcart, otherwise there'd be no hope.

Well, to tell you the truth, I love it too.

Give my head a pain once in a while, but I too like the flexibility.

I would like to see a nitrus system put in the trunk tho. This thing move mighty slow at times. Even when you do what you can to lighten the load.

Add me to your list and let me know what churns out of the ol experiment bag.

AND, if MS thinks about this cart, slam the door in their face. ha

[NuAlpha]

Originally Posted by markwhoo

I would like to see a nitrus system put in the trunk tho. This thing move mighty slow at times. Even when you do what you can to lighten the load.

Sorry, too simplistic for my tastes. I would prefer a large flywheel suspended in frictionless helium-4 superfluid loaded into the trunk, rotating at 150,000RPM to store energy while the car is stopped. Good for that extra kick to take you from 0-60 in less than 3 seconds.

By the way, heard some group was really going to try the above. Wish I could find the Popular Mechanics edition they published that in...or was it Popular Science...ahh well.

[markwhoo]

Originally Posted by NuAlpha

Sorry, too simplistic for my tastes. I would prefer a large flywheel suspended in frictionless helium-4 superfluid loaded into the trunk, rotating at 150,000RPM to store energy while the car is stopped. Good for that extra kick to take you from 0-60 in less than 3 seconds.

By the way, heard some group was really going to try the above. Wish I could find the Popular Mechanics edition they published that in...or was it Popular Science...ahh well.

All I can say is if someone finds the system that works FAST! I hope they share the love.

[Stephen Hatton]

Hi NuAlpha

I'm in for any generic mods you have / wish to make.

You have proven yourself!


Regards
Ing. Stephen Hatton

[cybrgman]

Just an FYI

Doesn't work with PHP 4.2.2
Fatal error: Call to undefined function: file_get_contents()

I had such high hopes