Click here to Skip to main content
15,881,455 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi, I need a little help with someting I'd like to implement, but not sure how to do it.

Image classifieds site like eBay. There are a lot of filters there: by price, by category, by city, by condition...
Let's say we have this use case:
- User is able to search eBay using filters
- Once he does it he can save those filters and subscribe to get push notification when someone submits an ad that matches those filters
- I save those filters in my database for that user

For this example let's say that site has around 100k active subscriptions.

The first step is obviously to attack a place in a code where ad is being saved to the database. I'm having a problem with how to know if that specific ad matches those filters.

I would need to go through 100k subscriptions and their filters to know which filter matches the ad that has been posted. It doesn't sound too good for me, it could be 1M filters or more.

Can someone help me with that? What would be the best way to solve the problem?

What I have tried:

I tried to through 100k of records and execute filters to see if ad matches. That doesn't work
Posted
Comments
OriginalGriff 24-Sep-20 5:19am    
"It doesn't work" is probably the most useless problem report we get - and we get it a lot. It tells us nothing about what is happening, or when it happens.
So tell us what it is doing that you didn't expect, or not doing that you did.
Tell us what you did to get it to happen.
Tell us any error messages.
Tell us what help you need!
Use the "Improve question" widget to edit your question and provide better information.
F-ES Sitecore 24-Sep-20 5:39am    
You can be sure eBay doesn't run off one server :) I would say have 1,000 servers and divide the searches across all your servers.
ZurdoDev 24-Sep-20 7:41am    
I don't quite understand what you are asking. You could use ebay's api to do searches and return all results to user.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900