West Wind Web Store
Candidate index question
Gravatar is a globally recognized avatar based on your email address. Candidate index question
  Michael B
  All
  Nov 30, 2021 @ 07:27am

Hi Rick,

From time to time our system will 'lock up' due to a blank record getting saved in either our wws_invoice or wws_lineitem tables. We have not been able to figure out what causes the insert to fail without data, but when it happens it shuts down our ability to process orders.

I was curious if your old store code creates candidate indexes or if that was something we did. We have had it this way for 20 years so changing it not obvious. Any comments on using candidate indexes on dbfs would be great.

Thanks!

Gravatar is a globally recognized avatar based on your email address. re: Candidate index question
  Rick Strahl
  Michael B
  Nov 30, 2021 @ 01:08pm

Not quite sure what you're asking. The store uses pre-generated primary keys (ie. not auto-inserted by the DB).

if you have candidate keys then that's likely something that you added...

+++ Rick ---

Gravatar is a globally recognized avatar based on your email address. re: Candidate index question
  Michael B
  Rick Strahl
  Nov 30, 2021 @ 01:25pm

I am on a wild goose chase, so I thought I'd ask you if you ever heard of candidate indexes causing any drama in the framework. I know/knew that it was a long shot.

We only recently changed our pk's to candidate indexes (for a 3rd party data sync'g app - dbconvert). Since We had the issue long before that, not likely the issue. It just seemed to coincide with this new app we were testing.

No worries!

Thanks for the quick reply.

© 1996-2024