Index too small

Andrew Cetinick's Avatar

Andrew Cetinick

20 Jan, 2012 03:54 AM

Hi,

I really am interested in using Heroku for my application hosting, but I am concerned in the use of Flying Sphinx within my application. I have millions of rows (9-10) that I will need to have indexed using Sphinx, and I am assuming that the indexes would be very large.

How much is 5gb for indexing ? Is it enough ?

  1. Support Staff 2 Posted by Pat Allan on 20 Jan, 2012 04:06 AM

    Pat Allan's Avatar

    Hi Andrew

    It really depends on how you have Sphinx configured, and how much data is indexed for each record. Flying Sphinx will let you go over your limit, though, and then warn you if you're over for a week. So feel free to give it a shot. I'd be surprised if you need more than 5gb - but again, it depends on several different variables.

    I'd suggest giving it a spin and see how you go. Happy to discuss further, if you'd like.

    Cheers

    Pat

Reply to this discussion

Internal reply

Formatting help / Preview (switch to plain text) No formatting (switch to Markdown)

Attached Files

You can attach files up to 10MB

If you don't have an account yet, we need to confirm you're human and not a machine trying to post spam.

Keyboard shortcuts

Generic

? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac