This is where its at:
V8 multisite
stock held on a local shared access database.
database has 6k+ products
site has about 500 products
custom var set up (manufacturer)
linked to a standard text field field in the access database
this setup casues actinic to go slow. really slow. moving a single product from 'unallocated external products' to the shop takes minutes not seconds.
making a change to a product or section takes minutes to commit after the 'apply' button is pressed.
Ive tried this on several sites linked to the database. all react the same.
If i link the same external field to any standard actinic variable then its fine, everything is fine - no issues, so it has to be a problem
with linking to custom variables.
I've another site that has a linked database with only 34 items in it - that site has no speed issues when using external fileds linked to custom variables.
so I am wondering if actinic v8 has a useability limit where customvars linked to external data are concerned?
does anyone else have a custom var taking data from an external database in a site that has thousands of products? if so, does it work OK for you?
and yes ive compacted both actinic and shared stock databases before you ask!
in the mean time, i'm going to use one of the standard variables to hold my brand and manufacturer data for google product purposes - just have to find one that accepts text and isnt used anywhere by my sites!
V8 multisite
stock held on a local shared access database.
database has 6k+ products
site has about 500 products
custom var set up (manufacturer)
linked to a standard text field field in the access database
this setup casues actinic to go slow. really slow. moving a single product from 'unallocated external products' to the shop takes minutes not seconds.
making a change to a product or section takes minutes to commit after the 'apply' button is pressed.
Ive tried this on several sites linked to the database. all react the same.
If i link the same external field to any standard actinic variable then its fine, everything is fine - no issues, so it has to be a problem
with linking to custom variables.
I've another site that has a linked database with only 34 items in it - that site has no speed issues when using external fileds linked to custom variables.
so I am wondering if actinic v8 has a useability limit where customvars linked to external data are concerned?
does anyone else have a custom var taking data from an external database in a site that has thousands of products? if so, does it work OK for you?
and yes ive compacted both actinic and shared stock databases before you ask!
in the mean time, i'm going to use one of the standard variables to hold my brand and manufacturer data for google product purposes - just have to find one that accepts text and isnt used anywhere by my sites!
Comment