Main Area and Open Discussion > General Software Discussion

Why is my computer hiccuping every few seconds?

<< < (11/12) > >>

cmpm:
On another performance note that may apply.
I've found my computer to perform more smoothly and better response time with letting MS handle the visual effects. I've turned some off and there was a lag for response time on most everything.

But when I reset it to windows choosing what's best, it, W7, performed better.
Could be in my mind's eye but I'm more pleased with it's performance.

f0dder:
40hz: probably just to get a robust(!) and relatively fast datastore for free - dunno if they use any relational stuff or complicated queries (I would think not). Better alternatives, pray do tell! SQLite is the first thing I'd consider if I needed a compact file-based database.

40hz:
^Perhaps I should have phrased my comment better. By better choices I meant no database at all rather than a different one. I'll agree that, within its intended scope of use, SQLite is probably as good as it gets right now.

But what exactly is it they're storing that actually needs a database? Favorites? Cookies? Browsing history? How big a performance gain would that provide no matter how big a list you had?

Dunno. Seems like they're swatting a fly with a sledgehammer. Unless they wanted to hold user data in a place that would be relatively easy for something on the server-side to query. Hence my original question: What's it really there for?

 :)

Ath:
But what exactly is it they're storing that actually needs a database? Favorites? Cookies? Browsing history?
-40hz (February 10, 2011, 01:59 PM)
--- End quote ---
Correct, they build a search index as big as all words that where on all pages you viewed. But then they don't know how to find anything back in that pile... sort of. (not true)

Just open a new tab in FF, and start typing (in the 'address' field, not the search field) some words that where in URL's or pages you visited recently with FF. The suggestions are always pretty good, and saved my ass a few times, because I couldn't remember what site some info was on, but FF could! :up:

Bamse:
Yes, awesomebar/places was the reason for going sqlite. Old dat/html something format was worse! Long lists are not fast and manageable because they are not in sqlite format. You can query all day long in library via commands, there is an extension for this I think, but how many do that? Is 1 out of 1000 interested in Places Query Syntax ? Database can do a lot more than what most see. Sqlite might be overkill if you know all "database" features but is it not almost a standard solution for programmers when they need more than "lists"? Many programs use it or that is my impression.

If sqlite is sqlite regardless of where it is used how to implement must mean a lot. Long time ago I read a database expert freaking out about how Firefox handled places. Make one change and it is like whole database must be reindexed/updated. Why I suffered managing 1000s of bookmarks on old 3.0 version. Hd, whole computer was almost freezing for minutes when you did simple copy/paste functions in bookmark sidebar. That was also powered by sqlite.

History/Places change quite a bit in 4 btw Places got Async Expiration

Navigation

[0] Message Index

[#] Next page

[*] Previous page