I think I've figured most of it, but the part that's confusing me is the "index" stuff. What does this refer to? How should I use it? Where are the chocolate chip cookies?
Watch
GitHub Core
Show your support for Zikula! Sign up at Github account and watch the Core project!
GitHub Modules
Forum Activity
- internetking created topic »password problem« 25. May
- mesteele101 responded to »ERR (3): E_USER_ERROR: Smarty error: [in pagesvar:pagesitem2en line XXX]…« 25. May
- mazdev responded to »Pages 2.5.0 and updating - Page not found« 25. May
- ehdwma created topic »Hide "Register new account" and change template to 3 col« 25. May
- mesteele101 responded to »Zikula 1.3.3 - Selecting a category in Pages not working« 25. May
- mdee created topic »How to implement returnpage ?« 25. May
- nestormateo responded to »Fillters in Clip« 24. May
Zikula Blog
- Anatomy of Open Source Projects on Mar 07
- Continuous Review on Mar 01
- Not Invented Here on Feb 24
- How to Contribute Your Code at Github on Jan 13
- 10 Steps to Coding-Nirvana: Tips for Successful Module Writing on Nov 12
- Submitting Bug Report Tickets That Get Results on Aug 17
- Cozi Tricks #1: Syntax Highlighting on Aug 07
Login
Question on the new initialization stuff
-
**unknown user**
- Rank: Softmore
- Registered: Mar 16, 2002
- Last visit: Oct 21, 2009
- Posts: 379
Posted: Sep 22, 2005 - 05:19 AM
I've been trying to wrap my already-overstretched brain around the new initialization stuff in .760. Is there a guide on whatever method is being used?
I think I've figured most of it, but the part that's confusing me is the "index" stuff. What does this refer to? How should I use it? Where are the chocolate chip cookies?
-
- Rank: Legend
- Registered: Dec 11, 2002
- Last visit: Oct 21, 2009
- Posts: 11674
Posted: Sep 22, 2005 - 05:27 AM
The scripts use the adodb data dictionary That might help you a little.
--
itbegins.co.uk - Zikula Consulting
birtwistle.me.uk - Personal Blog
Please read the Support Guide -
**unknown user**
- Rank: Softmore
- Registered: Mar 16, 2002
- Last visit: Oct 21, 2009
- Posts: 379
Posted: Sep 22, 2005 - 05:37 AM
That does help a lot, actually. So the index thing helps the selects and such perform faster, yes? Any good resources (besides the MySQL docs, which I'm reading now) or tutorials on indexing? I think I've got my primary keys indexed, but I'm not sure what else needs to be poked and prodded. :) -
**unknown user**
- Rank: Freshman
- Registered: Mar 16, 2002
- Last visit: Oct 21, 2009
- Posts: 98
Posted: Sep 22, 2005 - 08:08 AM
Quote
but I'm not sure what else needs to be poked and prodded. Smile
A good rule of thumb is if you are going to look up based on that field or sort based on that field index it. Hope that helps. -
- Rank: Legend
- Registered: Dec 11, 2002
- Last visit: Oct 21, 2009
- Posts: 11674
Posted: Sep 22, 2005 - 08:40 AM
Anything you reguarly use in a WHERE clause is good. So, if you ever search by username for example.
--
itbegins.co.uk - Zikula Consulting
birtwistle.me.uk - Personal Blog
Please read the Support Guide -
**unknown user**
- Rank: Softmore
- Registered: Mar 16, 2002
- Last visit: Oct 21, 2009
- Posts: 379
Posted: Oct 06, 2005 - 07:39 AM
Okay, I have a list of fields that I think I need to index. Some of them are text fields, though, not varchars. Is it possible to index them? I'm getting error messages and not sure why, but that seems like it might be a problem.
(And yes, I checked the MySQL docs but couldn't find anything. .) :)
- Moderated by:
- Support
