OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Do Base in Calc

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
jesuisbenjamin
General User
General User


Joined: 10 Mar 2010
Posts: 36
Location: Milky Way

PostPosted: Thu Mar 03, 2011 11:37 pm    Post subject: Do Base in Calc Reply with quote

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
Back to top
View user's profile Send private message
RPG
Super User
Super User


Joined: 24 Apr 2008
Posts: 2697
Location: Apeldoorn, Netherland

PostPosted: Fri Mar 04, 2011 2:53 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
ftack
Moderator
Moderator


Joined: 27 Jan 2003
Posts: 3102
Location: Belgium

PostPosted: Fri Mar 04, 2011 4:12 am    Post subject: Reply with quote

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)
Back to top
View user's profile Send private message
jesuisbenjamin
General User
General User


Joined: 10 Mar 2010
Posts: 36
Location: Milky Way

PostPosted: Fri Mar 04, 2011 6:26 am    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
RPG
Super User
Super User


Joined: 24 Apr 2008
Posts: 2697
Location: Apeldoorn, Netherland

PostPosted: Fri Mar 04, 2011 7:07 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group