- Notifications
You must be signed in to change notification settings - Fork 136
Open
Description
Hi,
I am investigating a problem with high CPU usage. Here is my server:
Windows Azure
Premium v2 P2V2
210
CPU 2
Memory 7
Remote Storage 250
Scale 30
I am not using the same server with 4 CPU and 14 GB memory and the server is fine. Does GraphQL require more CPU and RAM?
Here is my graph QL query:
string commonFields = @" fragment OrderFields on Order { customer { firstName lastName } id name note createdAt updatedAt email discountCode tags channelInformation { channelId channelDefinition { handle channelName } } registeredSourceUrl sourceIdentifier displayFinancialStatus displayFulfillmentStatus cancelReason cancelledAt closedAt confirmed currencyCode paymentGatewayNames poNumber taxesIncluded test totalDiscounts totalPrice totalTax totalWeight fulfillments { location{ id name } id status trackingInfo { company number url } createdAt updatedAt order { id } } originalTotalDutiesSet { presentmentMoney { amount currencyCode } shopMoney { amount currencyCode } } app { id name } taxLines{ channelLiable price rate ratePercentage title } discountApplications(first: 100) { edges { node { value { ... on MoneyV2 { __typename amount currencyCode } ... on PricingPercentageValue { __typename percentage } } allocationMethod index targetSelection targetType ... on DiscountCodeApplication { __typename code allocationMethod index targetSelection targetType value { ... on MoneyV2 { __typename amount currencyCode } ... on PricingPercentageValue { __typename percentage } } } ... on ManualDiscountApplication { description value { ... on MoneyV2 { __typename currencyCode amount } ... on PricingPercentageValue { __typename percentage } } allocationMethod index targetSelection targetType title } ... on ScriptDiscountApplication { __typename allocationMethod description targetSelection index targetType value { ... on MoneyV2 { __typename currencyCode amount } ... on PricingPercentageValue { __typename percentage } } title } } } } shippingLines(first: 10){ edges { node { id code price originalPriceSet { shopMoney { amount currencyCode } presentmentMoney { amount currencyCode } } source title discountedPriceSet { shopMoney { amount currencyCode } presentmentMoney { amount currencyCode } } taxLines { rate title price priceSet { presentmentMoney { amount currencyCode } shopMoney { amount currencyCode } } } } } } lineItems(first: 30) { edges { node { id title name sku quantity totalDiscount variantTitle customAttributes { key value } variant { id } product { id } fulfillmentService { serviceName } discountAllocations { discountApplication { index } allocatedAmount { amount } allocatedAmountSet { presentmentMoney { amount currencyCode } shopMoney { amount currencyCode } } } vendor isGiftCard requiresShipping fulfillableQuantity originalUnitPrice taxLines { price rate title priceSet { presentmentMoney { amount currencyCode } shopMoney { amount currencyCode } } } originalUnitPriceSet { shopMoney { amount currencyCode } presentmentMoney { amount currencyCode } } discountedUnitPriceSet { shopMoney { amount currencyCode } presentmentMoney { amount currencyCode } } } } } currentTotalDiscountsSet { presentmentMoney { amount currencyCode } shopMoney { amount currencyCode } } currentSubtotalPriceSet { presentmentMoney { amount currencyCode } shopMoney { amount currencyCode } } currentTotalPriceSet { presentmentMoney { amount currencyCode } shopMoney { amount currencyCode } } currentTotalTaxSet { presentmentMoney { amount currencyCode } shopMoney { amount currencyCode } } transactions(first: 5) {
paymentDetails {
... on CardPaymentDetails {
avsResultCode
company
cvvResultCode
number
name
paymentMethodName
bin
}
}
amount
createdAt
id
kind
gateway
formattedGateway
status
test
amountSet {
presentmentMoney {
amount
currencyCode
}
shopMoney {
amount
currencyCode
}
}
}
tags shippingAddress { firstName lastName address1 address2 city country zip company provinceCode countryCode province phone name longitude latitude } billingAddress { firstName lastName address1 address2 city country zip company provinceCode countryCode province phone name longitude latitude } }"; if (finalQuery.Contains("gid://shopify/Order/")) { gqlQuery = $@" {commonFields} query {{ order(id:""{finalQuery}"") {{...OrderFields }} }} "; } else { gqlQuery = $@" {commonFields} query ($first: Int, $after: String) {{ orders(first: $first, after: $after, query: ""{finalQuery}"") {{ edges {{ node {{ ...OrderFields }} }} pageInfo {{ hasNextPage endCursor }} }} }}"; } response = await _client.SendQueryAsync<dynamic>(new GraphQLRequest { Query = query }); I also loop through and map the fields:
Let me know your thoughts.
Metadata
Metadata
Assignees
Labels
No labels
