1,532 reputation
2428
bio website bhdp.com
location Cincinnati, OH
age 27
visits member for 1 year, 5 months
seen Mar 31 at 14:55

Applications Analyst

Homebrewer


Mar
31
awarded  Popular Question
Mar
19
accepted Workflow queueing
Mar
19
comment Workflow queueing
Thanks, that's the kind of answer I was looking for! Well as long as it's not going to cause a problem I'll likely just try leaving a general ItemChanged workflow up and let it do its thing when the list is updated. Seems like the easiest solution to me. I'll be interested to see what the performance impact is, because that may cause me to change my solution, but until then I think simple is better.
Mar
19
asked Workflow queueing
Mar
11
accepted Performance: SQL query vs SPListItemCollecion
Mar
11
comment Performance: SQL query vs SPListItemCollecion
Seems SQL handles things well enough that I don't need the extra lists to store the items. I was wondering if running queries like this would disrupt operations but so far it doesn't. Performance-wise there is a bit of a benefit to using queries instead of list item collections, so as long it's not hurting the SQL server I'll stick with that method.
Mar
11
comment Performance: SQL query vs SPListItemCollecion
Ah thanks for the info. I'll build the webpart that way and see how it performs.
Mar
11
revised Performance: SQL query vs SPListItemCollecion
Clarified and updated with new idea
Mar
11
comment Performance: SQL query vs SPListItemCollecion
It's actually on the same SQL server, guess I should have mentioned that. What I'm really thinking about though, is which method would be faster at indexing and looping through the collections of data? If I run a foreach against an SPListItemCollection searching for specific data will it perform differently than if I used a LIKE statement in a new SQL query?
Mar
11
asked Performance: SQL query vs SPListItemCollecion
Mar
6
asked Filter and sort related data from multiple lists
Mar
5
revised InfoPath 2013 form causes “Server out of memory” error when viewing list item
Updated with new findings
Mar
5
comment InfoPath 2013 form causes “Server out of memory” error when viewing list item
Okay I removed all the data sources that weren't needed but the symptoms are still the same. I did manage to make a template from the list (though without content, trying that causes an error) to experiment on, but it is showing identical symptoms. Any more ideas?
Mar
3
comment “nativehr” error while trying to delete list items through ProcessBatchData
I'll restructure the batch to look more like yours and see if that helps. I can't find any documentation on the differences between 10 and 13 in this regard, so it's pretty much just a "guess and check" situation unfortunately
Feb
28
asked “nativehr” error while trying to delete list items through ProcessBatchData
Feb
26
comment InfoPath 2013 form causes “Server out of memory” error when viewing list item
That's what I thought but I tried deleting them and was denied because they're supposedly still in use. I'll double check all the fields to verify that.
Feb
25
comment InfoPath 2013 form causes “Server out of memory” error when viewing list item
No repeating fields, but there are 18 data sources, all pointing to very small lists in the same site. A good amount of those aren't even used but were created automatically when the field was created, though the fields had their choices switched to another data source and the originals can't be removed apparently.
Feb
25
comment InfoPath 2013 form causes “Server out of memory” error when viewing list item
There's no special code, the form was created strictly with oob controls. Could there still be a leak/loop? How would I check for it?
Feb
25
asked InfoPath 2013 form causes “Server out of memory” error when viewing list item
Feb
21
asked Search results including metadata keywords always “hidden”