X-Cart forums

[NuAlpha]

Originally Posted by B00MER

Not everyone runs 4.0-5.0 of MySQL. There are better ways to approach this, one query, and count the keys in the array holding the results with PHP instead of two queries with gobs of useless conditions that just slows down the server even more.

Tried this, actually. Keeping it in the DB using limits is over twice as fast. On our site it brought the average execution of func_search_products down from 4.5 seconds to 2.1 seconds.

I am a little confused about the necessity of keeping support for pre MySQL 4.0 in the latest Xcart releases. I can't even find a location to download version 3.x anymore.

[cherie]

Originally Posted by NuAlpha

I am a little confused about the necessity of keeping support for pre MySQL 4.0 in the latest Xcart releases. I can't even find a location to download version 3.x anymore.

Hosting companies may still be installing MySQL 3. Just a year ago I know some were, so those customers would still need the support.

[NuAlpha]

Originally Posted by cherie

Hosting companies may still be installing MySQL 3. Just a year ago I know some were, so those customers would still need the support.

Then perform conditional queries dependant upon the MySQL version. If you are concerned that a version of MySQL may not support the FOUND_ROWS() information function do something similar to the following example:

$query_results = func_query("SELECT /*! SQL_CALC_FOUND_ROWS */ * FROM $sql_tbl[products] WHERE ....");

$num_rows = func_query_first_cell('SELECT FOUND_ROWS()');

if ($num_rows === false) {
     $num_rows = func_query_first_cell("SELECT COUNT(*) FROM $sql_tbl[products] WHERE....");
}

The above would provide a speed boost to those that can support the query syntax and would still retain backwards compatibility for older clients without significantly complicating the code.

[rrf]

Originally Posted by NuAlpha

Really wishing I had a Mac. Vim and SubEthaEdit look very handy.

Though I can't really beat the PHP code checking abilities of Zend Studio with anything else yet.

Well, Vim is ported on virtually all platforms. Would not use it on platforms other than UNIX though. And IDEs like Zend Studio is definitely better for Windows.

Oops, going a little bit off-topic here

[cherie]

Originally Posted by rrf

Well, Vim is ported on virtually all platforms. Would not use it on platforms other than UNIX though. And IDEs like Zend Studio is definitely better for Windows.

Just to clarify, Linux and Mac OS X are UNIX derivatives, vim ships with Linux and Mac OS X, and Zend Studio is available for Linux and Mac OS X.

I also agree that shipping could use some more attention in this next version of X-Cart (keeping this post on topic ).

[B00MER]

Wise man said it best, opionions are like butts, everyone has one and they all stink.

I use UltraEdit and SmartFTP for coding.
Photoshop CS for image editing.

To sum the topic back up, X-Cart defiantly needs improvement on these areas:
- Shipping API's directly integrated
- Search optimizations (rewrite of include/search.php perhaps?) to handle large product/category databases. Along with offering a more relevant internal search to customers. More Details: http://cart-lab.blogspot.com/2005/10/improving-x-carts-search.html
- Improved Usuability (the new speed lane checkout is defiantly a good step towards this)

two cents deposited.

[shan]

yeh just to bring this thread back on topic now is the time for everyone to dive in and take a look at 4.1 beta.

if you dont have your say now you can hold your breath for another year

what we should be looking at is bug reports / comments on usability etc

if there is something that has bugged you using x4.0 and before nows the time to have your say..............

[cherie]

How about managing options for multiple products? I just tried adding an option for more than one product. It had six products in my list of products I am modifying at once and the new option only added to the first two. I've always had problems duplicating options (modifiers or variants) among multiple products. It would be so nice to be able to setup an option for one product then duplicate it among 100 other similar products.

[shan]

Originally Posted by cherie

How about managing options for multiple products? I just tried adding an option for more than one product. It had six products in my list of products I am modifying at once and the new option only added to the first two. I've always had problems duplicating options (modifiers or variants) among multiple products. It would be so nice to be able to setup an option for one product then duplicate it among 100 other similar products.

what happens if you list all the products you want to change in admin...

- choose modify selected
- choose options etc

does this apply the options to them all ?

[NuAlpha]

Another nicety would be if stored and encrypted credit card information was accessible by the customer at checkout instead of having to re-enter the information again each visit. This would further streamline the checkout process for everybody's favorite type of customer...the one that comes back for more.