Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

wALF
wALF
Offline

Badges

Badges
11

Accepted Solutions

Accepted Solutions
0

Likes Received

Likes Received
4

Posts

Posts
32

Discussions

Discussions
3

Questions

Questions
30

Ideas

Ideas
0

Blog Posts

Blog Posts
0
Top badges earned by wALF
Customize the badges you want to showcase on your profile
Re: Database or table partitioning for performance benefits - Adobe Campaign 27-01-2022
Hi Stephen, Yes, we're completely hosted and although we're not running into massive performance issues but we were thinking if DB partitioning helps boost the performance a bit more, why not. Your response makes a whole lot of sense and I totally agree. This query was raised just to gain insights and understand the efforts vs. benefits. We'd be interested with just the custom tables, tbh. We've been informed Postgres is hosted on RDS and hence not possible but an internal ENH has been raised by...

Views

150

Like

1

Replies

1
Re: Database or table partitioning for performance benefits - Adobe Campaign 18-01-2022
Turns out there is not a single customer using partitioned Postgres database. Sadly, Adobe support says this is something that isn't supported by ACC as there are no cases available to answer our queries.Is there a way we could raise an exception request so they can try this out on their local sandbox to confirm this works well compared to un-partitioned data? Just trying to get partitioning certified by Adobe. -wALF

Views

184

Likes

0

Replies

4
Re: Database or table partitioning for performance benefits - Adobe Campaign 11-01-2022
Thanks Joyti. Although the second link wasn't accessible, the first one summarizes some good tips that can be helpful. I can now check with Adobe Support for I was particularly looking for database partitioning. Before we could consider, I wanted to have a clear understanding on the benefits vs. efforts of doing so. -wALF

Views

196

Likes

0

Replies

0
Database or table partitioning for performance benefits - Adobe Campaign 09-01-2022
Hi guys,We all know database partitioning helps on the performance front. I'm keen to know if anyone has implemented DB or table level partitioning in a completely hosted ACC environment and what are/were the challenges that got in the way. -wALF

Views

208

Likes

0

Replies

7
Re: Finding enum fields with string value - Adobe Campaign 28-06-2021
Great Cedric ... that worked well for us.

Views

450

Likes

0

Replies

0
Re: Finding enum fields with string value - Adobe Campaign 20-06-2021
This certainly looks helpful. I shall try and revert on this.

Views

476

Likes

0

Replies

0
Finding enum fields with string value - Adobe Campaign 17-06-2021
We have several enum fields (dropdown to choose from) in several tables having value as string data type. We are wanting to make them numeric for performance reasons. What's the best way to identify all such enum fields?

Views

570

Likes

0

Replies

4
Re: Workflow in started state and Delivery in "Pending de... - Adobe Campaign 17-06-2021
Hi Greeshma,What Jon meant was, are all the recipients of the delivery in the Sent state or some of them in the Pending state? Secondly, the mta is required so please confirm if the mta service running?We see the same issue but for our triggered emails (Message Center) where the recipients appear in Sent or Ignored state on RT but Pending on the marketing instance. -Harshal

Views

568

Likes

0

Replies

0
Re: Identifying long running waits/workflows - Adobe Campaign 24-05-2021
Thanks Cedric, as this is certainly helpful. However, the Heatmap feature crashes and is about to be fixed in upcoming releases. Even if we agree the underlying runwf process doesn't run (with a Wait activity), the temp tables (workflow or delivery) will continue to be held by the tool, innit? So, some resources continue to be consumed and can be released.

Views

744

Likes

0

Replies

0
Re: Identifying long running waits/workflows - Adobe Campaign 13-05-2021
Hiya, We have that package installed. However, it only provides you with what is currently running on your DB server (innit?). Moreover, it won't list if your workflow is waiting (via Wait activity) and with every refresh, it'll flush out those that have completed and list down only the ones currently running. -wALF

Views

773

Likes

0

Replies

0
Likes given to