all data is live and searchable



« Back . [new search - developer's notebook] . [new search - adilas community funded projects]
Basic Assignments
 
Options & Settings
 
Main Time Information
Color Code: Pink
Assigned To: Stephen Berkenkotter
Created By: Cory Warden
Created Date/Time: 11/8/2019 12:00 pm
 
Action Status: Completed
Show On The Web: Yes - (public)
Priority: 0
Finished/Done: No - (open)
Finished/Done By: ...
Budgeted/Estimated Value: 1,000.00  
Actual/Real Value: 0.00   [donate]
Invoice/Quote Status: Blank (n/a)
General Amount: $0.00
 
Time Id: 1550
Template/Type: Community Funded Projects
Title/Caption: Slow Load Times When Adding Items to Cart
Start Date: 11/8/2019
End Date: Unknown... (open or blank)
Total Time: Unknown... (open or blank)
Target/Due Date: 11/8/2019
Main Status: Active
Sorry, no photos available for this element of time.

Notes:

Completed on 11/26/19

11/25/19: Brandon, Steve and Alan are meeting on this issue Mon, Tues and Wed this week to make some headway.

From Steve: 11/8/19:I've cc'd in Cory so she can add a ticket and we will dig into this issue. Thanks for the awesome explanation and details.

I'm thinking maybe the table(s) involved need to be indexed better or we have some queries that are lagging and need updated.

Have a good weekend and I'll follow up on this with you asap.

From Ian 11/8/19: I've been fielding a bunch of employee feedback (which is actually filtered-down customer-feedback) regarding slow load times when adding items to the cart. I can confirm that load times are 5-7 seconds for each item when scanning a barcode (either subid or a package tag). This adds up when budtender needs to make 7-10 scans. It can take over a minute in just page loads and creates an experience that is unexplainable to the customer..We've been very diligent  about closing old packages and disabling subs, we've also been good about making old parents inactive. We have a very minimal amount of opens subs that are not actually for sale on the floor. What else can we do to speed this up?

Additional Comments/Notes - Subs (1)
Title/Caption Date Time Done By Comment/Note
Update 12/2/2019 8:41 am Stephen Berkenkotter

Alan and Brandon finished this project. They added another setting to Corpwide setting 37 called Sub Barcodes.


37.
Cart Quick Search Drop-Down:
 Part Numbers (default)
 Flex Grid Tie-Ins
 Recipe/Builds
 Cart Favorite Buttons
 Barcodes (mixed sources)
 Sub Barcodes		This setting deals with a special cart specific quick search on the top of the view cart page (how to search your items). The default is to have only the "Part Numbers" option selected. If this is the only selection that is chosen, the cart quick search drop-down menu will be hidden (users won't even see it as an option). The term "Part Numbers" still allows for a flexible 4-way search of the part number, the reference number, the part description, and the barcode assigned to the main part number. Once again, this is the main default and is sufficient in most cases. The other options should only be selected if your corporation actively uses those options to search items for adding them to the cart. The "Barcodes (mixed sources)" option will actually do a search of all of the cart quick search options at the same time. This is very flexible but may take a slightly longer time to complete the search. Technically, there are barcode fields for part numbers, barcode fields for flex grid tie-ins, barcode fields for recipe/builds, and barcode fields for cart favorite buttons. The reason this option has the words "mixed sources" is because it will try to search all of the sections for a match at the same time. The "Sub Barcodes" option is just for sub inventory and deals with ~, ^, qr_, and other sub barcodes (tied to sub inventory). This search will not do the normal wildcard searches and is specifically designed for quick, known sub inventory values.