PicaJet User Forum Forum Index PicaJet User Forum
PicaJet - Digital Photo Management Software
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Crashing Queries

 
Post new topic   Reply to topic    PicaJet User Forum Forum Index -> Problems and Troubleshooting
View previous topic :: View next topic  
Author Message
keir



Joined: 18 Nov 2005
Posts: 35

PostPosted: Mon Nov 28, 2005 7:29 pm    Post subject: Crashing Queries Reply with quote

When I click on my larger categories, I now get an error that says:
"You select too much criteria for query! Cannot display results."
If I attempt to do a search on one of those categories, the program crashes.
That's the whole reason I got picajet! I want to query one category based on another. If you can't do this, what's the point! If it comes down to the number of pictures in each category, I can guarantee they are only going to get bigger over time.
Back to top
View user's profile Send private message
Alex
PicaJet Team


Joined: 18 Feb 2005
Posts: 340

PostPosted: Thu Dec 08, 2005 12:15 pm    Post subject: Reply with quote

You have sended your database some time ago. We look throught it. This is very big database. One parent has over two thousand child categories. This message is result of the PicaJet's limitation.
Back to top
View user's profile Send private message Visit poster's website
keir



Joined: 18 Nov 2005
Posts: 35

PostPosted: Thu Dec 08, 2005 4:55 pm    Post subject: Reply with quote

Can't you get rid of the limitations? I understand that a query of this size may take longer, but I have a necessary query and a necessary category structure. The main purpose of my database is to organize my plant pictures. Each plant has to have its own name, each of those needs to be under their family, and they all need to be under a basic plant category. This gives the basic structure of plant_category/family/scientific_name. In the future there will likely be as many as 10,000 child categories, maybe more. I also have a separate category structure for the locations the photos were taken. How can I find out which plant photos were taken in a certain area if I can't query the main plant category? It seems that, as far as database queries go, it can't get much simpler than that.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    PicaJet User Forum Forum Index -> Problems and Troubleshooting All times are GMT
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