I've been spending about 10 hours on creating a sort of Javascript database... just to find out that the computer that'll be using it is so slow that it takes about 4 minutes to give results of a search query..
Here's the details:
- I have about 60 000 entries.
- To make design & update easier, I've separated the list into 25 js files.
- Each js files is an new Array creator with the entries being new values to the array.
- I have a search script that looks at each entrie to find the query and then display it in the document.

Problem is: with 60k+ entries, the search takes an eternity to complete on a slow compu (under P3-500Mhz)

Is there any way to speed up the process? If it implies changing my entire program and using something else, I'm open to it (now that's a first!)

using something else, I'm open to it (now that's a first!)

Use a serverside scripting (and a database server)? :D At least the process will be done in the server, the visitor's browser will only need to parse HTML.

Learning one like PHP isn't hard if you have a programmer's logic, Most different programming languages only have different syntax. You can start in php.net, phpfreaks.com, this forum, and a lot more.

---
Site of the Day

Well.. nice try Laler... sorry to disappoint you. I'm stuck with a working environnement that doesn't give me the possibility to use PHP... If I could, trust me I would be using it. PHP is one that I use very often! :D

Here's the catch: I don't have any internet access on the computer. This script I'm creating will be used ocally, not on a server.

So... right now, a real database isn't possible. That's why I reverted to an Javascript Array and tried my best with what I was given.. but now I'm stuck again.

Any more ideas?

ah ic :D

well, I have no idea then. using offline webserver like dwebpro or mini-apache will give even slower result on a 500 MHz PC, don't you think?

I have a P3 866 Mhz. With it, opening page with 'javascript fading rollover' annoys me, with any browser =D So I don't see how it'll work with your 60000 rows database smoothly.

Maybe someone will have a better idea :D

---
Site of the Day

Yeah, javascript in-browser is not a data-crunching language. Browsers are notorious for js memory leaks anyway. I would even choose use an Excel VBA over this. But you can still use a java applet or flash object. These runtimes are more performance-oriented.