at this point, Sesame's Sparql's prepared queries only seem slightly faster
Fri, 09/07/2007 - 00:37 — jonathan
RESULTS || Simple 0.2760002613067627 || Prepared 0.2669997215270996
Here are results of running the scripts against the database of 90,000 statements - 34 queries, in about .3 seconds.
It retrieves all distinct properties, then loops through and retrieves all distinct values for those properties.
The punchline : after a number of tests, prepared queries at this point are only slightly faster. I may cache the tuple query in quercus APC - but for now, the regular queries are sufficiently fast.
COUNT of 33 DISTINCT TOTAL PROPERTIES
| http://www.w3.org/1999/02/22-rdf-syntax-ns#type | Simple 52 (0.06000018119812012 seconds) | Prepared 52 (0.06099987030029297 seconds) |
| http://www.w3.org/2000/01/rdf-schema#comment | Simple 3 (0 seconds) | Prepared 3 (0 seconds) |
| http://www.w3.org/2000/01/rdf-schema#label | Simple 5705 (0.026000022888183594 seconds) | Prepared 5705 (0.021000146865844727 seconds) |
| http://www.w3.org/2000/01/rdf-schema#subClassOf | Simple 17 (9.999275207519531E-4 seconds) | Prepared 17 (9.999275207519531E-4 seconds) |
| http://www.w3.org/2000/01/rdf-schema#domain | Simple 1 (0.0010001659393310547 seconds) | Prepared 1 (0 seconds) |
| http://www.ahirc.org/namespaces/semantic_search/Property#field_ahirc_description_0 | Simple 4227 (0.01399993896484375 seconds) | Prepared 4227 (0.01399993896484375 seconds) |
| http://www.ahirc.org/namespaces/semantic_search/Property#field_ahirc_scope_0 | Simple 53 (0.015000104904174805 seconds) | Prepared 53 (0.01699995994567871 seconds) |
| http://www.ahirc.org/namespaces/semantic_search/Property#field_approved_0 | Simple 2 (0.016000032424926758 seconds) | Prepared 2 (0.013000011444091797 seconds) |
| http://www.ahirc.org/namespaces/semantic_search/Property#field_entered_0 | Simple 4115 (0.013000011444091797 seconds) | Prepared 4115 (0.013000011444091797 seconds) |
| http://www.ahirc.org/namespaces/semantic_search/Property#field_last_update_0 | Simple 4569 (0.01699995994567871 seconds) | Prepared 4569 (0.023000001907348633 seconds) |
| http://www.ahirc.org/namespaces/semantic_search/Property#field_referral_0 | Simple 2 (0.012000083923339844 seconds) | Prepared 2 (0.013000011444091797 seconds) |
| http://www.ahirc.org/namespaces/semantic_search/Property#field_website_0 | Simple 5338 (0.019999980926513672 seconds) | Prepared 5338 (0.019999980926513672 seconds) |
| http://www.ahirc.org/namespaces/semantic_search/Property#field_ahirc_site_sponsor_0 | Simple 1843 (0.013000011444091797 seconds) | Prepared 1843 (0.009000062942504883 seconds) |
| http://www.ahirc.org/namespaces/semantic_search/Property#field_ahirc_phone_1_0 | Simple 3356 (0.013000011444091797 seconds) | Prepared 3356 (0.01399993896484375 seconds) |
| http://www.ahirc.org/namespaces/semantic_search/Property#field_resource_webpage | Simple 52 (9.999275207519531E-4 seconds) | Prepared 52 (0 seconds) |
| http://www.ahirc.org/namespaces/semantic_search/Property#field_general_notes_0 | Simple 821 (0.004000186920166016 seconds) | Prepared 821 (0.003999948501586914 seconds) |
| http://www.ahirc.org/namespaces/semantic_search/Property#field_ahirc_keywords_0 | Simple 55 (0 seconds) | Prepared 55 (9.999275207519531E-4 seconds) |
| http://www.ahirc.org/namespaces/semantic_search/Property#field_ahirc_services_0 | Simple 10 (9.999275207519531E-4 seconds) | Prepared 10 (0 seconds) |
| http://www.ahirc.org/namespaces/semantic_search/Property#field_best_bet | Simple 4 (0 seconds) | Prepared 4 (0 seconds) |
| http://www.ahirc.org/namespaces/semantic_search/Property#field_ahirc_phone_2_0 | Simple 658 (0.0019998550415039062 seconds) | Prepared 658 (0.003000020980834961 seconds) |
| http://www.ahirc.org/namespaces/semantic_search/Property#field_ahirc_fax_0 | Simple 481 (0.003000020980834961 seconds) | Prepared 481 (0.002000093460083008 seconds) |
| http://www.ahirc.org/namespaces/semantic_search/Property#field_ahirc_address_0 | Simple 967 (0.003999948501586914 seconds) | Prepared 967 (0.003000020980834961 seconds) |
| http://www.ahirc.org/namespaces/semantic_search/Property#field_ahirc_city_0 | Simple 296 (0.003000020980834961 seconds) | Prepared 296 (0.002000093460083008 seconds) |
| http://www.ahirc.org/namespaces/semantic_search/Property#field_ahirc_state_0 | Simple 54 (0.006999969482421875 seconds) | Prepared 54 (0.004999876022338867 seconds) |
| http://www.ahirc.org/namespaces/semantic_search/Property#field_ahirc_zip_code_0 | Simple 627 (0.003000020980834961 seconds) | Prepared 627 (0.0029997825622558594 seconds) |
| http://www.ahirc.org/namespaces/semantic_search/Property#field_ahirc_address_continued_0 | Simple 320 (0.003999948501586914 seconds) | Prepared 320 (9.999275207519531E-4 seconds) |
| http://www.ahirc.org/namespaces/semantic_search/Property#field_last_chk_0 | Simple 3098 (0.021000146865844727 seconds) | Prepared 3098 (0.021999835968017578 seconds) |
| http://www.ahirc.org/namespaces/semantic_search/Property#field_ahirc_contact_0 | Simple 74 (9.999275207519531E-4 seconds) | Prepared 74 (0 seconds) |
| http://www.ahirc.org/namespaces/semantic_search/Property#field_ahirc_contact_phone_0 | Simple 6 (0 seconds) | Prepared 6 (0.0010001659393310547 seconds) |
| http://www.ahirc.org/namespaces/semantic_search/Property#field_ahirc_contact_title_0 | Simple 2 (0 seconds) | Prepared 2 (0 seconds) |
| http://www.ahirc.org/namespaces/semantic_search/Property#field_ahirc_secondary_contact_0 | Simple 15 (9.999275207519531E-4 seconds) | Prepared 15 (0 seconds) |
| http://www.ahirc.org/namespaces/semantic_search/Property#field_ahirc_service_area_0 | Simple 10 (0 seconds) | Prepared 10 (0 seconds) |
| http://www.ahirc.org/namespaces/semantic_search/Property#field_eligibility_notes_0 | Simple 80 (0 seconds) | Prepared 80 (0.0010001659393310547 seconds) |
RESULTS || Simple 0.2760002613067627 || Prepared 0.2669997215270996
