6151 posts
  • Sells items exclusively on Envato Market
  • Elite Author: Sold more than $75,000 on Envato Market
  • Has sold $125,000+ on Envato Market
  • Has been part of the Envato Community for over 6 years
+8 more
VF says

We gave it a go a while ago using our current main search system, but with over 1.2 million comments it kind of choked on the volume. We’re gradually switching over to a new search system (starting with photodune) that hopefully will work on those kind of data volumes…. so hopefully we can add it in a future project.

Any update on this? Atleast after 2 years.

954 posts
  • Has referred 1+ members
  • Has sold $1,000+ on Envato Market
  • Has been a beta tester for an Envato feature
  • Won a Most Wanted contest
+3 more
aleluja says


Cheers Jami and John

Good to hear..

Still not entirely sure why it is so complex. All of the data is within the dB and is stored in I presume comment arrays with product id’s etc etc..

So it really shouldnt matter if there are a Billion comments in the system.. as you are already drilled down within the product comments.. when you are on that area…

To assume all the comments are within one array is quite scary and erm.. a tad daft. A good sql fella could whip up the correct db query in a few mins

Essentially, the request would only be > search via comments for product id “blah blah Blah”

Anyhoo look forward to it.

Yes, the query itself is simple, i guess that it’s more because of the optimization and performance. Envato maybe uses MySQL, so when 1000000000* users search for comments (+ add already searching for items), site gets overloaded.

That’s why Facebook or similar use graph databases, for some stuff they are much faster.

*maybe slightly exaggerated number :D

Facebook was using cassandra before the graph search and it was doing good job.

1 post
  • Has been part of the Envato Community for over 3 years
  • Has collected 1+ items on Envato Market
hebegb1 says

or just let to print all comments on 1 page (user can search comments by ctrl+f)

+10000000

18 posts
  • Has referred 10+ members
  • Has sold $5,000+ on Envato Market
  • Has collected 50+ items on Envato Market
  • Has been part of the Envato Community for over 5 years
+1 more
TheAlikA says

or just let to print all comments on 1 page (user can search comments by ctrl+f)

Agreed! Currently I am doing just that, but paging through all the pages – 10, 20 pages… that’s a lot of clicks and CMD+F ’s

5 posts
  • Has been part of the Envato Community for over 2 years
  • Has collected 100+ items on Envato Market
SurmountStudios says

We request this function, too!! Thank you :D

25 posts
  • Has been part of the Envato Community for over 6 years
  • Has collected 50+ items on Envato Market
Spiv says


or just let to print all comments on 1 page (user can search comments by ctrl+f)
+10000000

+99999999

365 posts
  • Has been part of the Envato Community for over 5 years
  • Has collected 500+ items on Envato Market
  • Located in United Kingdom
kops says

My fix at the moment is to use a browser pagination plugin to display all the comments on one page and then CTRL-F.

Try https://addons.mozilla.org/en-us/firefox/addon/repagination/ for Firefox

or

https://chrome.google.com/webstore/detail/igiofjhpmpihnifddepnpngfjhkfenbp for Chrome
2196 posts
  • Located in Europe
  • Made it to the Authors' Hall of Fame
  • Had an item featured on Envato Market
  • Participated in a focus group or interview to improve the user experience on Envato Market
+10 more
revaxarts says
1664 posts
  • Has referred 50+ members
  • Has sold $40,000+ on Envato Market
  • Has collected 10+ items on Envato Market
  • Won a Most Wanted contest
+9 more
flashedge says

If search volume is an issue, limit the queries to purchasers and author.

1472 posts
  • Elite Author: Sold more than $75,000 on Envato Market
  • Made it to the Authors' Hall of Fame
  • Has been part of the Envato Community for over 6 years
  • Has sold $250,000+ on Envato Market
+5 more
fuelthemes says

If search volume is an issue, limit the queries to purchasers and author.

That would be great

Helpful Information

  • Please read our community guidelines. Self promotion and discussion of piracy is not allowed.
  • Open a support ticket if you would like specific help with your account, deposits or purchases.
  • Item Support by authors is optional and may vary. Please see the Support tab on each item page.

Most of all, enjoy your time here. Thank you for being a valued Envato community member.

Post Reply

Format your entry with some basic HTML. Read the Full Details, or here is a refresher:

<strong></strong> to make things bold
<em></em> to emphasize
<ul><li> or <ol><li> to make lists
<h3> or <h4> to make headings
<pre></pre> for code blocks
<code></code> for a few words of code
<a></a> for links
<img> to paste in an image (it'll need to be hosted somewhere else though)
<blockquote></blockquote> to quote somebody

:grin: :shocked: :cry: Complete List of Smiley Codes

by
by
by
by
by
by