Do Base in Calc

jesuisbenjamin · Posted: Thu Mar 03, 2011 11:37 pm Post subject: Do Base in Calc

Hello there,

I am using Base to process data from a survey for my studies. It's very slow and i found it quite unstable.
Can i use Calc and perform SQL commands and functions? I'm not so familiar with Calc when it's getting technical, but it seems to handle the amount of data faster.

Thanks.
Benjamin

RPG · Posted: Fri Mar 04, 2011 2:53 am Post subject:

Hello

What Operating system you use?
What kind of database engine you use?. See left down your window.

I have helped some body with a kind of servey. We start with MS Excell. For control I did use also OOo-base. The result for me was that I think it is better to use a database. The database can even be based on a spreadsheet but then you meet fast the limits. In the end when you want have some results from the database then use again your spreadsheet. OOo is real good to handle it.

Maybe you have to study a little how SQL is working.

Romke

ftack · Posted: Fri Mar 04, 2011 4:12 am Post subject:

If you are quite familiar with SQL, why not use a database such as sqlite? You could probably do much of your data processing using SQL on the command line. You can still connect to that sdlite database using Base if you have a need to change or input data in a graphical environment.
_________________
--
GNU/Linux (Ubuntu)

jesuisbenjamin · Posted: Fri Mar 04, 2011 6:26 am Post subject:

I am using Ubuntu 10.10.
The database is "embedded database" using the "HSQL database engine".
I am familiar with SQL. This is why i used Base for my purpose, because i had no idea how to query on Calc. The ability to create a form is also what motivated my choice, so i can input my data easily.
I will try your suggestions (although i am not sure i understand the first completely).

Thanks.
B.

RPG · Posted: Fri Mar 04, 2011 7:07 am Post subject:

Hello

The first problem was: OOo-base is slow.

When you search on this forum then you can find that problem more. I don't knew a solution for Ubuntu but with openSUSE 11. 3 I must go back to java 6.0.20. I'm not sure but the problem started maybe with 6.0.22. Also I don't know if the problem with JAVA with OOo-base. But for me when I go back to java 6.0.20 OOo-base was fast and not more slow.

I have copied some links here

Maybe this link can help you more
http://www.oooforum.org/forum/viewtopic.phtml?t=114636&highlight=
http://ubuntuforums.org/showpost.php?p=10251666&postcount=10
Romke