Architecture :: Manage Wish List For Product Catalog?
Jul 6, 2010
i m developing a product Catalog. All fine, i want to manage wish list for product, which user wish to see, now my question is that how can i manage this wish list, coz i have no uniqueness of the user, coz ny one whether it is registerd or not can wish the product in my scope, i thought to distinguish the user by their IP address becoz this wish list is temporaray, how can i delete the record when user close the browser if go to the IP address for distinguish..
I am wondering if there are any good articles you could point me to that would present the implementation details or options for delivering advanced search capabilities. Like what we see at [url] and similar Web sites offering vast numbers of products to be searched. The search process for these starts with a simple "Search" text box - usually with auto-suggest. Then the user can drill down and narrow the search by [for example] price, manufacture, size, capacity, and other relevant attributes of the product being searched.
When I navigate such sites and search for products, drilling down into the various categories, it's easy to think that there is some complex engine behind the scenes that generates dynamic SQL to satisfy the various and potentially extensive criterion required to satisfy the search requests.
Or could it be simpler than that? In any case, I understand this question may not have a specific answer; so I'm hoping for some article or reference implementation I could study. Short of that, if any of you have implemented advanced search of a product catalog (presumably searching products stored in a reasonably normalized database; through 3NF or so); any critical implementation considerations would be appreciated. I'm particularly interested in the meta data that may have to be present in the underlying data set in order to satisfy some of the search requests.
I am building UI for a large product catalog (millions of products).
I am using Sql Server, FreeText search and ASP.NET MVC.
Tables are normalized and indexed. Most queries take less then a second to return.
The issue is this. Let's say user does the search by keyword. On search results page I need to display/query for:
Display 20 matching products on first page(paged, sorted) Total count of matching products for paging List of stores only of all matching products List of brands only of all matching products List of colors only of all matching products
Each query takes about .5 to 1 seconds. Altogether it is like 5 seconds.
I would like to get the whole page to load under 1 second. There are several approaches:
Optimize queries even more. I already spent a lot of time on this one, so not sure it can be pushed further.Load products first, then load the rest of the information using AJAX. More like a workaround. Will need to revise UI.Re-organize data to be more Report friendly. Already aggregated a lot of fields.
I checked out several similar sites. For ex. [URL]. Not only they display the same information as I would like in under 1 second, but they also include statistics (number of results in each category).
The following is the search for keyword "white" [URL] How do sites like zappos, amazon make their results, filters and stats appear almost instantly?
Is there any good code (paid or open source) out there for:Handling PPC ads on our site? This would (hopefully) include pages to create ads, reports of ads run, determining what ad to show, and tracking billing.Adding comments to our site? This would (hopefully) include up/down/inappropiate votes on other's comments.A product catalog? This would (hopefully) include advanced search and entering product items.
I am going to create the SAAS (Software as a service) Application. Can you please provide all the attributes that we have to consider in SAAS application (for example usability, pluggable architecture etc .. )
How architecture should be build for this project, provide sample architecture for SAAS application. This architecture should be easy to upload and upgrade or degrade the features. Error handling should be easy.
I'm refactoring an old website that has product search code littered throught the codebehind. I'm trying to encapsulate the search logic into its own class so I've created a Product class with a Search() method. I would like some suggestions about OO best practices so that the class is reusable and maintainable. The questions I have are:
- Should I make the search() method an instance method or make it static? For now the class is just really there to encapsulate my search logic
- If I make it an instance method should it return a list of products or should it populate a member property that I can access like p.Search(); var x = p.ProductList;
- The search method requires upward of 7 parameters of different types, what's the best way to provide them? - pass them all i.e. p.Search (param1, param2, ..., param7) - create a SearchParams structure in the class, populate it and pass that i.e. p.Search(searchParams) - Instantiate a Product object and set properties on it that are used by the Search method i.e. p.ID = 123; etc.... p.Search();
I've used variations of the above before but would like to know what's the best way.
I am developing a job portal for a company who is operation in mumbai.
I wil have a functionality that job seeker can upload their resume. I want to know that what is the best way to manage those uploaded file so that my application will no go down by performance.
I work with asp.net , VB script (web developer 2008)
I need to build page for x product (every user have number of product) and every line i show the product picture + name + listBox the show to the user how much packege he want to buy (0-10)
the button run to see what product the user order (>0 packedges)
how to show at every line(Row) the ListBox , and how to find the product that the user wants
I have created SQL CLR database project in 2010. when I try to deploy it to sql server 2008, it gives me error like Msg 6528, Level 16, State 1, Procedure UmAlQuraConverter, Line 2 Assembly 'SqlClassLibrary' was not found in the SQL catalog of database so, how to add SqlClasslibrary to sql catalog
I have different roles like Administrator ,Accountant, Clerk,Enforcment When user open Catalog Zone to add parts to Web part Zone i want only those parts should apper on the screen for which user selected Group,like if user selected Enforcement Group then Parts of that group should only appear in the Catalog Zone.
I want Catalog Zone cantains to be depend on which Group user was selected.
This is my first time using autocomplete. I have everything up and running, but I want to return a list of more relevent keywords or phrases from my full text catalog, or the table that I search against. I have no idea where to start as far as my getcompletionlist goes.
So If I type in knee a list appears kneepads
here's my getCompletionList Public Function GetCompletionList(ByVal prefixText As String, ByVal count As Integer) As String() Dim items As New List(Of String) Dim myConnectionString As String myConnectionString = GetSQLConnString() Dim mySelectQuery As String = "SELECT ShortDescription FROM ProductInfo WHERE FREETEXT(ShortDescription, @prefixText) OR FREETEXT(LongDescription, @prefixText) OR FREETEXT(ProductHTML, @prefixText) OR FREETEXT(PartNumber, @prefixText) ORDER BY RANK() OVER (Order BY PartNumber, ShortDescription, LongDescription)"
I am debating between 2 scenarios for handling the display of a product catalog for a website redesign I am performing. I will be using the IIRF isapi filter to perform the rewriting for an asp.net website.
Here is what the urls will look like
[URL]
[URL]
[URL]
etc...
There will be a total of 8 or 9 product group pages
Scenario 1: I have these pages rewrite to one general purpose page that will look something like this:
[URL]
Then I decide which catalog to display with a switch/case based on the querystring. All of the code for displaying the catalogs would be based off of one page.
Scenario 2: I create a separate page for processing each different catalog page. The rewriting would look something like this then:
[URL]
Then each catalog page would have it's own .aspx to handle the processing and display of that group of items.
I am developing an intranet application that needs to authenticate against a global catalog server (containing about 14 domains). What would I use for the connection string?
I'm really new at asp.net 3.5 I'm comming from Classic ASP and I have been experimenting with ASP.NET. I'm trying to use the ListView Control to display a products catalog comming from a database. My first test was succesfull but I have a question.I want to be able to display the title of the product in Bold if certain conditions exists for that product. I tried using the ItemDataBound event but I don't know how I to get the value from the database field.I have the following code
ASPX PAGE
[Code]....
CODE BEHIND
Protected Sub productsList_ItemDataBound(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.ListViewItemEventArgs) Handles productsList.ItemDataBound
We have a wfc layer that wraps the business classes and database access and use a client that lives on the database layer. Amongst our group we are attempting to form standards. Some want to have the client call the web method and pass the page they are requesting and the page size. Pass that to the database and then page in SQL Server use RowNum.Some want to cache the full list of objects in http cache on the service tier and page in memory. They concern here is memory use on the server.
Which would be best for a medium number of users with potentially large number of records to manage (say 30K) Is it better to cache them all in memory and work from there or page at the database as the application scales?
I am looking details on the internal working of asp.net architecture. The topics need to include the following:
Asp.Net Thread/Application Pools HttpRuntime HttpApplication - When and how it is set up How HttpContext is set up How objects can passed along the pipeline using HttpContext.Current.Items Why does modification of static variables requires locks in ASP.NET (advanced)IIS 7 Integration Mode
i want to create a centralised business or Service authendication architecture in .net. for example, we have a clients like c1, c2, c3, c4, ... etc. everybody logins seperatly as well as grouply. ie, if client "C1" logins [with login authentication] he can access c2 , c3, c4 also without login authendication. So its like a google. if we enters gmail account, we can access orkut, picasa like that.. i need the cetralised architecture.
And, client "c1" seperately asks seperately how will be the authendication architecture.
so give me the single solution for both these two scenarios. how will be the architecture for these two and how is the Data Base (Login) Structure.
