Need simple help Installing Sphinx on win32 system.

2013-08-09  Source: Original Site  Category:Sphinx  Views:2 

Advertisement

I am new to mysql & sphinx so please bare with me if i get a few things wrong...

Firstly i have a table with over 39,000 Rows of data... (approx 1.38 gb of data)
Each row contains stripped text from web pages as well as a cached version of the page
from when i spidered it...

The problem is... running full text searches on indexed tables say for "dog" still takes
about 40+ seconds to complete... this is by far way two long for a user to wait for a
search...

After searching through sf.net & the mysqlforums i came to sphinx...

People say they can get results within 1sec with 100's of GB's of data with sphinx... so
i thought i would give it a go...

I have downloaded a copy on to the server hosting the database... but i am having trouble
installing it... tbh i have no idea where to start, the documentation is not that clear
for win32 systems.

Would anyone be able to help me / guide me in the write direction with the setup of
sphinx on a win 2k3 server running MySQL 5.

Related articles
  • Need simple help Installing Sphinx on win32 system. 2013-08-09

    I am new to mysql & sphinx so please bare with me if i get a few things wrong... Firstly i have a table with over 39,000 Rows of data... (approx 1.38 gb of data) Each row contains stripped text from web pages as well as a cached version of the pa

  • Ubuntu Need Some help installing 2012-10-24

    Ok heres the deal: I got a free cd from canonical with 8.10 ubuntu iso and I really want to get this into my new Asus notebook (Centrino 2, 4 GB RAM, 320 GB disk) I had to use the "help me boo from CD" option in the autorun menu of the CD, and I got

  • Need help installing Ubuntu on new system 2014-03-08

    I just built a new computer with the help of a friend and unfortunately he had to leave and leave me with a computer with no OS. Being that I'm slowly learning about computers i need help installing ubuntu. From a CD i get most of the way through the

  • Need major help installing gtk+ on ubuntu 2014-04-20

    I'm using Ubuntu 8.04, and I need to install gtk+ 2.18.2 for a development project. I am fairly new to Linux, and do not know much about the operating system besides basic functionality and configure/make/make install type things. The application I a

  • Ubuntu Need some help installing my hard drives and GPU 2013-03-28

    guys, I installed the Ubuntu 8.04 a few days ago and I'm having some problems with my Drivers and my old Windows Hard Drives. This is the information about my computer Intel Core 2 Duo E4500 Processor Motherboard ASUS P5B XFX Nvidia GeForce 9600GT 51

  • Pls help : installing sphinx search on 64bit ubuntu intrepid 2012-09-01

    I have intel core2duo box with 2gb RAM with 64bit ubuntu intrepid ibex i am trying to compile install sphinx search 0.9.8.1 on it i have all the prerequisites installed for compiling the source like build-essentials etc. i am able to do ./configure b

  • need simple help with Sessions in pHP 2014-03-28

    i just need a simple help with php sessions. i have 2 pages... page1.php and page 2.php contents of page 1.php <?PHP session_start(); $_session['key'] ='on'; ?> contents of page2.php <?PHP session_start(); echo $_session['key']; ?> why is

  • Ubuntu Need some help installing nvu and vlc 2014-04-06

    I need help installing nvu and vlc because I looked for them in sanaptic and nothing comes up.. I did a terminal and that wont work either!!! Help please!!

  • I need your help to develop my information system 2014-06-10

    everybody, I need your help. My proffesor told me that I have 7 days to choose what information system I want to develop. I know what I want, I want to make a project for "Hospital" (becouse hospital's in my country still use paper for everything and

  • questio Join Date: Apr 2006 Bean Count Hidden Question Need some help installing nvu 2015-05-15

    I need help installing nvu and vlc because I looked for them in sanaptic and nothing comes up.. I did a terminal and that wont work either!!! Help please!!

  • need procedure to install mysql in my system 2015-03-30

    I am new to the mysql database. Now i want to install MySql in my local system i have downloaded mysql 5.0 version and now i am unable to install this. Please tell me the procedure to install in my local system.

  • Ubuntu need help installing on new amd system 2013-06-21

    i am new to ubuntu i have just bilt a new AMD system i a having problems installing ubuntu 7.10 on it here is the specs AMD ATHALON 64X2 2.2GHZ ASROCK ALIVE NF6G - vsta NVIDIA 7200GS 80 GIG SEAGATE HDD (BLANK) 80 GIG MAXTOR HDD (HAS VISTA INSTALLED O

  • Help Installing mcrypt on Win32 2015-01-28

    I've got php and mysql installed on an NT4 box, running IIS webserver. I'm trying to install enable the ability of my php pages to use mycrypt(). I've downloaded the compiled mcrypt binaries (4.3) for win32 (link from php.net). The readme file says t

  • Ubuntu Newbie needs some help installing movie and music players 2015-04-24

    Ok, I have a few very Newbie questions... I need step by step answers please. 1. I need a movie player, everyone tells me mplayer, I downloaded it and tried to install it with the config files and I got this error: [email protected]:~$ /home/karishb

  • Ubuntu Need serious help installing 10.04 onto my broken laptop 2012-06-08

    I have a family member's old Dell 710m (x86 32-bit) laptop I'm trying to install Ubuntu 10.04 on and I'm finding out a lot of stuff does not work. [Disclaimer: I know basically nothing about hardware or troubleshooting these things beyond basic Googl

  • Ubuntu Need some help installing Pygtk... 2012-06-18

    I'm trying to install pygtk (mainly for "learning" puposes ;)) and I get an error. In the README file it tells me to type: $ ./configure --prefix=<prefix where python is installed> $ make $ make install So I find where python is located then I

  • Ubuntu Linux nub in need of help (Installing Software) 2012-11-11

    I'm working on updating a machine that has NovellSUSE on it. My goal is to get Kubuntu 8.10 on the machine. In another forum I found out what i need to do in order to get the LiveCD to work for me, but now I've hit a new problem. https://help.ubuntu.

  • Ubuntu Java & Gutsy - (need some help installing & uninstalling) thanks 2013-03-14

    hi i installed some java (see pic) i have no clue what java i really need can someone help Miro is acting all funny lately and always shuts down on startup what command do i have to typ in to get a full list of what java is already on my pc? so i can

  • Ubuntu in dire need of help installing ndiswrapper! 2013-06-29

    okay so i am absolute just-installed-ubuntu-yesterday noob at all of this, so if someone is willing to walk me through the process of getting wireless internet on this laptop, i will be eternally grateful. so i just installed ubuntu 9.04 onto my fami

  • Need some help installing Kernel Headers 2013-08-19

    there, I'm trying to install a program, but I've asked around, and the problem is, I need kernel header files. So, I had a few questions that I hope someone could answer. 1.) What are kernel headers? 2.) Why do I need them? 3.) How do I install them?