Somewhere on forum, Ingmar suggested to replace FR's bundled Firebird library with the newest version. I tried it, I noticed that FR performs db operations a bit quicker.
But I thought about other thing. Some people have installed a DB server on their machines (such as MySQL, pgSQL, etc).
Firebird is often slower than other db engines, may be you'll provide a SQL Abstraction Layer in Feedreader or something like that?
Greetings,
one more not, if you are testing 2.03 Firebird library,
for backup you must take gfix.exe and gbak.exe, from another zip file.
Somehow they are not included in fbembbeded zip file.
http://www.firebirdsql.org/index.php?op=files&id=engine_203
2007-09-24 Firebird-2.0.3.12981-1_win32.zip 5.6 Mb
SuperServer and Classic for Windows, zipped archive with folders structure
And extract them(gfix,gbak) to Feedreader directory, by default those files are in Bin subdirectory. But those files must be under FR dir.
If 2.0.3 seems to be stable release of Firebird, then we'll add this into next release. I have tested Firebird 2.1.0, with this release FR doesn't work.
If we are talking from different backends, then FR engine has support for MSSQL and MYSQL. It's used in Feedreader Connect Enterprise (commercial) product.
But if we release Feedreader with MSSQL/MYSQL support, then little bit (advanced) hacking and Feedreader(UI) acts as server(55%). After that we must close our "candy shop"...:(
I'm also for (powerful) free software, but how to prevent product abuse...
Set some kind of feed limits etc ?
Any ideas are welcome...
I'll present them in company meeting:)
Ingmar
------
FR dev
could there be a middle option ? i would like to purchase FR with MSSQL/MYSQL support but i can't pay 100 Euro every month..Only companies can :-(
regards Vidar
Greetings,
I fully understand, home users doesn't need such power that Feedreader Connect Enterprice provides. Gladly I'll raise this subject in next company meeting.
If we get green light, then 100% FR on different DB engine is for a small fee available (then I belive in next year 2008 first quater).
Which backend to use ?
MSSQL Express Edition (http://www.microsoft.com/sql/editions/express/default.mspx) or MYSQL.
As I see MYSQL is more required?
Ingmar
------
FR dev
"If we get green light, then 100% FR on different DB engine is for a small fee available (then I belive in next year 2008 first quater)"
sounds great :-)
Sorry, but I don't understand, what do you mean "to hack FeedReader UI".
There is a method to get into the FB's database file by everyone, I don't know how to hack it by db engine's changing...
You've publishied a db scheme, what a problem to change engine?
Set some kind of feed limits etc ? - restrict connection establishing to localhost only?
I'm asking about changing, because there are often CPU flood caused by performing db operations. I have about 190 feeds and updating a few at once, in by threads...
May will you move db handling to ODBC and publish db scheme for several engines? I think it would be a nice option...
When ODBC using is difficult (I think not), there are ntwdblib and libmysql for example...
Why use additional database, when different (faster) is active...?
--
eRIZ
http://eriz.pcinside.pl
eriz,
regarding CPU
there are things you can do...to limit the high CPU...i have 4 times the amount of feeds you have, over 800...and i to have probs...but then i clean the database...delete all feeds and then re import them via OPML..
first though, follow ingmar's advice
maybe there could be an option to totally clear the database, but keep the feeds and smartfeeds :-)
Vidar
Greetings,
// Why use additional database, when different (faster) is active...?
You are correct, embedded DB is not best option - everything works in same process, this slows down overall performance. FR on differenct DB requires memory 20 MB, currently 65-85mb.
This "hacking" was wrong use of words, more like "product abuse"...
For example company has bought this Homeuser edition...
then they will install this into one server, localhost in used.
But company website uses this MYSQL database to fetch data...
My suggetion would be, that
1) only localhost is allowed
2) check mysql->user table,are there users only in localhost
I FR we'll use ODBC;) no problems with this part...:)
Currently to speed up FR on (FB engine):
* run "C:\Program Files\FeedReader30\feedreaderbackup.exe" all options checked.
Then full backup/restore is done (indexed newbuilt, db internal garbage removed).
* download latest stable FB librarys (after unpacking into Feedreader directory, rename fbembedded.dll to fbclient.dll).
* Then from FR Tools-> Options -> Application properties -> Advanced page.
Choose: Add editional performance, press ok and restart FR.
After that FR will use more memory, but it's also faster. Then db engine is forced to used bigger buffers (for sorting, searching).
Ingmar
------
FR dev
But I can't understand one thing:
>For example company has bought this Homeuser edition...
>then they will install this into one server, localhost in used.
>But company website uses this MYSQL database to fetch data...
What is a difference in case of using Firebird engine on the server as it currently is? You've published database scheme, so I don't understand why are you "scared" - "abusing" is as possible as in Firebird or MySQL...
--
eRIZ
http://eriz.pcinside.pl
Greetings,
there are no secrets in Feedreader (maybe some in internal engine):))
For example with Firebird you can use only one
instance of FR and then this DB will be locked.
You can't access to this data remotly.
With MYSQL you can access DB remotly every time, every where;)
I'm maybe little bit paranoid:))) too many years near computers...
But I have seen also in companies such of hocus - pocus, to spare $25...:(
Ingmar
------
FR dev
Wow! Thanks for mentioning getting the newest Firebird. Things are much snappier, now, it seems. The only thing that didn't work was putting in the newest fbclient.dll -- that file messed things up
This is a different DB
This is a different DB engine but still, it's quite expensive. As a student at a informatics college I really need a free one that will work just like this one. Any ideas?
---
Mary-Anne Davis, search engine optimization specialist affiliate.